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 | 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) |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |