MVSFORUMS.com

pzmohanty · Posted: Sun Sep 05, 2004 3:14 am Post subject: db2 DAYNAME function

hi all,

we have a DAYNAME function which returns a mixed case character string containing the name of the day (e.g., Friday) for the day portion of the argument.

I had tried to use the DAYNAME function but got error.

following is the query :
1) SELECT DAYNAME(CURRENT DATE) AS WEEK_NAME FROM SYSIBM.SYSDUMMY1;

2) SELECT DSN8.DAYNAME(CURRENT DATE) AS WEEK_NAME FROM SYSIBM.SYSDUMMY1;

my other question is is their any SQL query to retrieve the DB2 version being used

Thanx in advn

P.R.Mohanty

kolusu · Posted: Mon Sep 06, 2004 6:32 am Post subject:

pzmohnaty,

Please search before posting. This topic has been discussed earlier. Check this link.

http://www.mvsforums.com/helpboards/viewtopic.php?t=2160&highlight=dayname

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu