Ashwin,
You can use the following commands to obtain the day of week on NT or UNIX:
db2 "values dayname(current date)"
db2 "select dayname(date('07/20/2001')) from sysibm.sysdummy1"
Thanks!
Narayan
-----Original Message-----
From: PATEL, Ashwin, MANU ITI [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 4:37 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Day of week
Hi All,
Is there anyway using SQL in DB2 to obtain the day of week e.g. if I have a
date in format 20/07/2001
I would like Monday or Mon to be returned.
I am using DB2 v7 on NT and using SQL stored procedures.
Thanks
Ashwin
----------------------------------------------------------------------------
----------------
"National Westminster Bank plc is registered in England No 929027.
Registered Office: 135 Bishopsgate, London EC2M 3UR.
National Westminster Bank plc is regulated by IMRO, SFA and Personal
Investment Authority. A member of the NatWest and Gartmore Marketing Group
advising on the life assurance, pensions and unit trust products only of
that Marketing Group.
This e-mail message is confidential and for use by the addressee only. If
the message is received by anyone other than the addressee, please return
the message to the sender by replying to it and then delete the message from
your computer.
Internet e-mails are not necessarily secure. National Westminster Bank plc
does not accept responsibility for changes made to this message after it was
sent."
----------------------------------------------------------------------------
----------------
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
