SQLBOL is your friend: SELECT DATENAME(month, getdate()) AS 'Month Name'
> -----Original Message----- > From: Paul Fennell [mailto:[EMAIL PROTECTED]] > Sent: 18 August 2002 10:12 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Bloody dates ...PIE !!!!!!!!!! > > > > Right I Have a known date in the Db > inthe format ... dd/mm/yyyy > > I want.. ( gawd why.. ) to get the date from a month as a string > Ie august.... > > but .. how the hell do you convert month as a string to an > 1-12 format with > out the silly > use of a massive switch statement or udf ... rar .. > > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
