Try
In UDB 6.1 on NT
DB2 SELECT Dayname(DATE('07/20/2001')) FROM SYSIBM.SYSDUMMY1
Cheers
Siva
---------------------------------------- Message History
----------------------------------------
From: [EMAIL PROTECTED]@lists1.ba.best.com on 07/20/2001 10:37 AM CET
Please respond to [EMAIL PROTECTED]
DELEGATED - Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
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
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
