• Login

DataSoft Corporation

DATENAME (datepart, date_exp)

Returns an English character string (a VARCHAR) that represents the datepart of date_exp. For example, a datepart month returns the name of the month such as January, February, and so forth. A datepart weekday returns the day of the week such as Monday, Tuesday, and so forth.

Datepart the part of the date to return, and must be one of the following values.

year
quarter
month
day
dayofyear
week
weekday
hour
minute
second
millisecond

Date_exp is an expression that returns a DATETIME value, a value that can be implicitly converted to a DATETIME value, or a character string in a DATE format. 

Thursday, 18 April 2019 Posted in Time and Date Functions
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.