[dba-SQLServer]Convert int month to char month

Aha... that did work! ;) Thanks!

Susan H. 


> You need to pass a datetime variable to convert. Try
> convert(datetime,cast('4/25/03' as datetime),107)
> 
> 107 is a style that should return MMM DD YYYY HH:MM
> See BOL for a list of styles.
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
> Harkins
> Sent: Friday, April 25, 2003 12:17 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer]Convert int month to char month
> 
> 
> Server: Msg 241, Level 16, State 1, Line 1
> Syntax error converting datetime from character string.
> 
> Got an error -- what's the 107? I'm using SQL Server 2000. 
> 
> Susan H. 
> 
> 
> > Ken,
> > Try something like this:
> > 
> > left(convert(datetime, mydate, 107),3)
> > 
> > This works in SQL2000, I don't know of convert exists in SQL7.
> > 
> > James Barash
> > 
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of 
> > Stoker, Kenneth E
> > Sent: Friday, April 25, 2003 11:27 AM
> > To: dba-SQLServer (E-mail)
> > Subject: [dba-SQLServer]Convert int month to char month
> > 
> > 
> > Does anyone know of a way to convert the return value of 
> > month([mydate]) from an integer to its equivalent char value?
> > 
> > 1 JAN
> > 2 FEB
> > 3 MAR
> > .....
> > 
> > Thank you for your help.
> > 
> > Ken Stoker
> > Technology Commercialization
> > Information Systems Administrator
> > PH: (509) 375-3758
> > FAX: (509) 375-6731
> > E-mail:  Kenneth.Stoker at pnl.gov
> > 
> > 
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > 
> > 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>