How do I convert a datetime field in MSSQL to MMDDYY format?
I have a select statement that I need tihe date, not the time portion that is stored in teh database.
The SQL that I have is :
SELECT TXT_Name, CONVERT(DATETIME, DA_ProfileCreationDate, 'mmddyy') AS Expr1
The DA_ProfileCreationDate has stored a date in the format of 2011-12-08 10:35:13.063 and I need the format 120811.