SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-43
DAY Function
DAY Function
The DAY function converts a DATE or TIMESTAMP expression into an INTEGER value
in the range 1 through 31 that represents the corresponding day of the month. The
result returned by the DAY function is equal to the result returned by the
DAYOFMONTH function.
DAY is an SQL/MX extension.
datetime-expression
is an expression that evaluates to a datetime value of type DATE or TIMESTAMP.
See Datetime Value Expressions on page 6-40.
Examples of DAY
•
Return an integer that represents the day of the month from the START_DATE
column of the PROJECT table:
SELECT start_date, ship_timestamp, DAY(start_date)
FROM persnl.project
WHERE projcode = 1000;
Start/Date Time/Shipped (EXPR)
---------- -------------------------- ------
1996-04-10 1996-04-21 08:15:00.000000 10
DAY (datetime-expression)