SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-39

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-39.

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)