Re: Extract Day of Week from Datetime

Qualify with WEEKDAY instead of DAY. nyc_ezrider@my-deja.com on 20/12/2000 07:15:42 Please respond to nyc_ezrider@my-deja.com To: informix-list@iiug.org cc: (bcc: Sue Davidson/EXE) Subject: Extract Day of Week from Datetime Is it possible to extract the Day of Week from a datetime data type column or determine the day of week with the current keyword? If I quantify datetime column with DAY I get the day of month. Can I get the way of week? EX: day(current) will return 19 today, can I get Tuesday or a value 1 (or 0) to 7 (or 6) with a 2 being Tuesday. Thanks, Frank Sent via Deja.com http://www.deja.com/