Date and Time Components For Date and Date-Time Functions

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