Skip to Content

mvSQL database function - DatePart()


Extracts a part from a date or datetime expression.


DATEPART(<datepart>, <datetime>)



Date Part Aliases Vendor Support
year yy, yyyy All RDBMS vendors.
quarter qq, q SQL Server and SQLite
month mm, m All RDBMS vendors.
dayofyear dy, y SQL Server and SQLite
day dd, d All RDBMS vendors.
week wk, ww SQL Server and SQLite
hour hh All RDBMS vendors.
minute mi, n All RDBMS vendors.
second ss, s All RDBMS vendors.

The date part must not be quoted.

The date part is not case-sensitive.


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


Returns an int that represents the date part.


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.


Expression Returns
DATEPART(minute, TIMESTAMP('1997-01-02 12:13:14')) 13
DATEPART(hour, TIMESTAMP('1997-01-02 12:13:14')) 12
DATEPART(day, TIMESTAMP('1997-01-02 12:13:14')) 2
DATEPART(month, TIMESTAMP('1997-01-02 12:13:14')) 1
DATEPART(year, TIMESTAMP('1997-01-02 12:13:14')) 1997