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 |