December 29, 2010 at 9:12 pm
Hi how do you format the date to return a date without the time ie January 10, 2010
December 29, 2010 at 9:37 pm
SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]
Check this link for further references
December 29, 2010 at 9:54 pm
Thank you 😀
That's a great link!
December 29, 2010 at 9:56 pm
You are most welcome
December 29, 2010 at 11:22 pm
Hi Abhijeet
Its really a useful link..Depicts almost all formats
Share more if u have anything related..It will help everybody
December 30, 2010 at 10:19 am
i use following link:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply