Date and time functions perform operations on DATE, TIME, TIMESTAMP, and TIMESTAMP WITH TIME ZONE data types.
SQL Anywhere includes compatibility support for Transact-SQL date and time types, including DATETIME and SMALLDATETIME. These Transact-SQL data types are implemented as domains over the native SQL Anywhere TIMESTAMP data type.
Many of the date functions use dates built from date parts. The following table displays allowed values of date parts.
When using date and time functions, you can specify a minus sign to subtract from a date or time. For example, to get a timestamp from 31 days ago, you can execute the following:
SELECT DATEADD(day, -31, NOW()); |
Date part | Abbreviation | Values |
---|---|---|
Year | yy | 1-9999 |
Quarter | 1-4 | |
Month | mm | 1-12 |
Week | wk | 1-54. Weeks begin on Sunday. A 54-week year occurs in leap years that start on a Saturday. |
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 |
Microsecond | mcs or us | 0-999999 |
Calyearofweek | cyr | 1-9999. 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-53. The week number within the year that contains the specified date. For more information about the ISO week system and the ISO 8601 date and time standard, see http://en.wikipedia.org/wiki/ISO_week_date. |
Caldayofweek | cdw | 1-7. (Monday = 1, ..., Sunday = 7) |
TZOffset | tz | -840 to 840 |
The following date and time functions are available:
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |