SQL Mask not using CF

2004-10-28 Thread Mickael
Hi All I was wondering if someone could help me out with the following SQL function. I would like to select Today(*) from my database but have it display as Thursday, October 28, 2004 This is easily done with a mask in CF but is there a way to do it right in my select statement? Something

Re: SQL Mask not using CF

2004-10-28 Thread Charlie Griefer
http://www.rocket99.com/sybase/sybase22.html see: Transact SQL: date/time formats Use the convert function to format the date into the style of your choice. On Thu, 28 Oct 2004 11:27:36 -0400, Mickael [EMAIL PROTECTED] wrote: Hi All I was wondering if someone could help me out with the