October 2001
Beginner to intermediate
400 pages
7h 45m
English
The following functions assist in performing calculations based on time- and date-related material. These are useful in performing calculations and transformations of temporal-related data sets.
The AGE function returns an interval that represents the difference between the current time and the time argument supplied.
AGE(timestamp)—Computes the difference between the timestamp supplied and now().
AGE(timestamp, timestamp)—Computes the difference between the two supplied timestamps.
AGE('03-01-2001 15:56:00', '11-01-2001 14:22:00') → 7 mon 30 22:26 ago The CURRENT_DATE function returns the current system date.
None.
SELECT CURRENT_DATE; → 2001-06-11 ...
Read now
Unlock full access