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

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-41

DAYOFMONTH Function

The DAYOFMONTH 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 DAYOFMONTH function is equal to the result

returned by the DAY function.

DAYOFMONTH 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 DAYOFMONTH

•

Return an integer that represents the day of the month from the START_DATE

column of the PROJECT table:

SELECT start_date, ship_timestamp, DAYOFMONTH(start_date)

FROM persnl.project

WHERE projcode = 1000;

Start/Date Time/Shipped (EXPR)

---------- -------------------------- ------

1996-04-10 1996-04-21 08:15:00.000000 10

DAYOFMONTH (datetime-expression)