Here is one option
SELECT (CAST(MONTH(DateField) AS VARCHAR(2)) + '/' + CAST(DAY(DateField) AS
VARCHAR(2)) + '/' + CAST(YEAR(DateField) AS VARCHAR(4))) AS NewDate
FROM AnyTable
You must use the CAST function to switch numbers to strings and the month,
day, year select the respective date parts numeric value
Enjoy
-----Original Message-----
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 10:14 PM
To: CF-Talk
Subject: Re: SQL date.
Geeez guys maybe I wasn't clear but I want to do this in a stored procedure
so CF isn't in the picture.
Thanks,
Neil
----- Original Message -----
From: "Shawnea Carter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 9:31 PM
Subject: Re: SQL date.
> #Dateformat(yourdatefield,"mm/dd/yyyy")#
>
> HTH
>
> Shawnea Carter
> ----- Original Message -----
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 5:42 PM
> 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
