Ashwin, take the DAYOFWEEK, DAYNAME function: values dayofweek(current date); values dayname(current date); best regards Joachim M�ller -------------------------------------------------------- Datenbanken DOUGLAS Informatik & Service GmbH Kabeler Stra�e 4 D-58099 Hagen Tel.:+49-2331-690-249 Fax:+49-2331-690-78-249 Mobile: +49-170-2221-249 mailto:[EMAIL PROTECTED] http://www.douglas-informatik.de "PATEL, Ashwin, MANU ITI" An: [EMAIL PROTECTED] <Ashwin.Patel@natwest. Kopie: com> Thema: DB2EUG: Day of week Gesendet von: [EMAIL PROTECTED] a.best.com 20.07.01 11:37 Bitte antworten an db2eug 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
