The following component names and values are supported as arguments for the date and date-time functions.
Component Name |
Valid Values |
---|---|
year |
0001-9999 |
quarter |
1-4 |
month |
1-12 |
day-of-year |
1-366 |
day or day-of-month |
1-31 (The two names for the component are equivalent.) |
week |
1-53 |
weekday |
1-7 (Sunday-Saturday) |
hour |
0-23 |
minute |
0-59 |
second |
0-59 |
millisecond |
0-999 |
microsecond |
0-999999 |
iWay Software |