August 8, 2007 at 12:26 am
Hi All,
I am currently trying to get a the day and month from a date in the following format.
07 July
30 December
Etc.
I am currently doing this by storing the dates in a table and then using the DatePart function to find the month then getting the month from my table.
I was simply wondering if anyone had come across a better method of doing this.
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 8, 2007 at 2:39 am
Does DATENAME do what you want? http://msdn2.microsoft.com/en-us/library/ms174395.aspx
James
--
James Moore
Red Gate Software Ltd
August 8, 2007 at 3:51 am
Thanks that is 100% perfect.
I should haev done more research before posting sorry
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 8, 2007 at 4:05 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply