Date Operations

Date operations allow you to extract portions of a date, time or timestamp field, perform date and time arithmetic; or test for valid date and time fields.

The date operation codes are used for date, time, timestamp fields, and character and numeric fields representing dates, times and timestamps.

The date operation codes are:

ADDDUR

Add a duration to a date or time.

EXTRACT

Extract part of a date, time or timestamp.

SUBDUR

Subtract a duration from a date or time, or calculate the duration between 2 dates, times or timestamps.

TESTTIME

Test for a valid date, time, or timestamp field.

See Also

Date and Time

Duration Codes