You can use the convert function with the style parameter as follows:-
convert(char(10),getdate(),101 )
Style parameters :
101 mm/dd/yyyy
110 mm-dd-yyyy
Hope this will help.
Regards,
CT Loo
----- Original Message -----
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 5:42 AM
Subject: SQL date.
> I would like SQL server to return the date in the format of mm/dd/yyyy
> without the time. Is this possible? Actually I know it possible the
> problem is how :)
>
>
> Thanks,
>
> Neil
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
