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
