Neoview SQL Reference Manual (R2.5)

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 a Neoview SQL extension.
DAYNAME (datetime-expression)
datetime-expression
is an expression that evaluates to a datetime value of type DATE or TIMESTAMP. See
“Datetime Value Expressions” (page 257).
Considerations for DAYNAME
The DAYNAME function returns the name of the day in ISO8859-1 encoding on a Neoview
platform that has the ISO88591 or SJIS configuration. It returns the name of the day in UCS2
encoding on a Neoview platform that has the Unicode configuration. For more information on
the Neoview character set configurations, see the Neoview Character Sets Administrator's Guide.
Example 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)
---------- -------------------------- ---------
2008-04-10 2008-04-21 08:15:00.000000 Thursday
388 SQL Functions and Expressions