Returns a mixed case character string containing the name of the day (e.g. Friday) for the day portion of the argument.
If expression is a character or graphic string, it must not be a CLOB or DBCLOB and its value must be a valid string representation of a date or timestamp. For the valid formats of string representations of dates and timestamps, see String representations of datetime values.
The result of the function is VARCHAR(100). If the argument can be null, the result can be null; if the argument is null, the result is the null value.
The CCSID of the result is the default CCSID of the current server.
National language considerations: The name of the day that is returned is based on the language used for messages in the job. This name of the day is retrieved from message CPX9034 in message file QCPFMSG in library *LIBL.
SELECT DAYNAME( '2003-01-02' ) FROM SYSIBM.SYSDUMMY1Results in 'Thursday'.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.