DAYS between DATES
DATE datatype
DATE to NUMERIC conversion
ADD MONTHS
Default DATE setting in BTEQ
HH:MI (Hour and Minutes format) in 24 hours time format
FIRST DAY of a MONTH
Computing the DAY of a week
HH:MI (Hour and Minutes format) with AM, PM notification
Integer to Time conversion
CALENDAR
CURRENT_TIMESTAMP
Difference between TIMESTAMP (0) and TIMESTAMP (6)
EXTRACT
Getting Current date and time
SUBTRACT MONTHS
ADD DAYS
ADD YEARS
ADD MONTHS in Arithmetic Operations on DATE
ADD MONTHS with INTERVAL
LAST DAY of a month
NUMERIC to DATE conversion
Coalesce for Date
AM and PM format in CURRENT_TIMESTAMP
Determining years (Age) with DATE functions
Arithmetic operations on DATE
BETWEEN for DATE types