88
Extracting information from date and time represen-
tations
There are six functions for extracting information from
date and time representations:
DAY(
date
) Returns the value of the day in
date
,
which is an integer in the range 1 to
31.
Example: DAY(DATE(96,9,11))
returns 11. DAY(“9/11/96”) returns 11.
MONTH(
date
) Returns the value of the month in
date
, which is an integer in the range
1 to 12.
Example: MONTH(DATE(96,9,11))
returns 9. MONTH(“9/11/96”) returns
9.
YEAR(
date
) Returns the value of the year in
date
,
which is a 4-digit integer representing
the year.
Example: YEAR(DATE(96,9,11))
returns 1996. YEAER(“9/11/96”)
returns 1996.
HOUR(
time
) Returns the value of the hour in
time
,
which is an integer in the range 0 to
23.
Example: HOUR(TIME(15,08,0))
returns 15. HOUR(“15:08:0”) returns
15.
MINUTE(
time
) Returns the value of the minute in
time
, which is an integer in the range
0 to 59.
Example: MINUTE(TIME(15,08,0))
returns 8. MINUTE(“15:08:0”) returns
8.
SECOND(
time
) Returns the value of the second in
time
, which is an integer in the range
0 to 59.
Example: SECOND(TIME(15,08,0))
returns 0. SECOND(“15:08:0”) returns
0.
To Next Page
Loading...
