SQL Dateformat problem
Posted on 2006-11-13
I wish to convert a datetime value to a string in the format YYYYMMDD where YYYY is the year, MM is the month with leading zero if appliccable and DD is the day, also with leading zero if appliccable.
EG. for 4th may 2006 the string would be 20060504
I am using microsoft SQL Server (2005)