Hi James,
Try something like
SELECT case DATEPART(m, mydate) when 1 then 'Jan'
when 2 then 'Feb'
when 3 then 'Mar'
...
end
----- Original Message -----
From: "James Silva" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 12:44 PM
Subject: [cfaussie] MSSQL7 datepart month as string
> Kind of off topic (sorry) but it would really save me a hell of a lot of
time if
> someone could tell me how to get MSSQL7 to return the month as a string
(not its
> numerical value, which is what i can extract atm).
>
> The field is a proper date field.
>
> Reason i ask is that im porting some SQL designed for MySQL and im fixing
up
> any/all DB specific code. I'd really like to avoid butchering the CFML if
> possible.
>
> thanks,
> _______________________
> James Silva
> Web Production
> Gruden Pty Ltd
>
> Tel: +61 02 9956 6388
> Fax: +61 02 9956 8433
> Email: [EMAIL PROTECTED]
> Web: www.gruden.com
> _______________________
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
>
> MX Downunder AsiaPac DevCon - http://mxdu.com/
>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
