mvSQL Database Function - DATENAME()¶

Summary¶

Returns a part of a date or date/time value with an English string representation for days and months.

Syntax¶

DATENAME(<datepart>, <datetime>)

Parameters¶

datepart¶

The date part must not be quoted.

The date part is not case-sensitive.

SQL Server calculates weeks using Sunday as the start of the week. SQLite, on the other hand, uses Monday.

datetime¶

Column or expression of type datetime or date. Some date parts expect a datetime.

Returns¶

Returns a string that represents the name of the given date part.

Regardless of whether it is returning a name "Monday", or a value that could be represented numerically (2015), that value will be a string.

Remarks¶

For Vinyl version 3.3.33893 and higher, all database vendors will now use ISO 8601 (weeks starting on Monday, starting at 1 on the first Monday of the year) for this function.

Earlier Vinyl versions handled date boundaries differently. For example, SQL Server calculates weeks using Sunday as the start of the week. SQLite, on the other hand, uses Monday.

Examples¶