Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » Function types » UltraLite date and time functions


Date parts

Many of the date functions use dates built from date parts. The following table displays allowed values of date parts.

Date part Abbreviation Values
Year yy 1-9999
Quarter qq 1-4
Month mm 1-12
Week wk 1-54. Weeks begin on Sunday.
Day dd 1-31
Dayofyear dy 1-366
Weekday dw 1-7 (Sunday = 1, ..., Saturday = 7)
Hour hh 0-23
Minute mi 0-59
Second ss 0-59
Millisecond ms 0-999
Calyearofweek cyr Integer. The year in which the week begins. The week containing the first few days of the year may have started in the previous year, depending on the weekday on which the year started. Years starting on Monday through Thursday have no days that are part of the previous year, but years starting on Friday through Sunday start their first week on the first Monday of the year.
Calweekofyear cwk 1-54. The week number within the year that contains the specified date.
Caldayofweek cdw 1-7. (Monday = 1, ..., Sunday = 7)