At the moment I have:
Which produces 11/19/2009, however I need it to read 200911 i.e. (YYYYMM)
asked Nov 19 '09 at 11:01 AM in Default
David 2 1
Here's one way:
answered Nov 19 '09 at 12:23 PM
My advice would be to format the date in your application, not in SQL Serer. If you format the date in SQL Server it will be sent as a text string to the application, rather than as a date/time datatype, and thus the applicaiton can do other useful things with it in its native format.
answered Nov 19 '09 at 02:39 PM