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

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—523725-004

9-44

DAYNAME Function

The DAYNAME function converts a DATE or TIMESTAMP expression into a character

literal that is the name of the day of the week (Sunday, Monday, and so on).

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

•

Return the name of the day of the week from the START_DATE column in the

PROJECT table:

SELECT start_date, ship_timestamp, DAYNAME(start_date)

FROM persnl.project

WHERE projcode = 1000;

Start/Date Time/Shipped (EXPR)

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

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

DAYNAME (datetime-expression)