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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-86
MONTHNAME Function
MONTHNAME Function
The MONTHNAME function converts a DATE or TIMESTAMP expression into a
character literal that is the name of the month of the year (January, February, and so
on).
MONTHNAME 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 MONTHNAME
•
Return a character literal that is the month of the year from the START_DATE
column in the PROJECT table:
SELECT start_date, ship_timestamp, MONTHNAME(start_date)
FROM persnl.project
WHERE projcode = 1000;
Start/Date Time/Shipped (EXPR)
---------- -------------------------- ---------
1996-04-10 1996-04-21 08:15:00.000000 April
MONTHNAME (datetime-expression)