[dba-SQLServer]Convert int month to char month

Stoker, Kenneth E Kenneth.Stoker at pnl.gov
Fri Apr 25 10:26:52 CDT 2003


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 




More information about the dba-SQLServer mailing list