What is the data type of your column? You can find that out by running this query:SELECT DATA_TYPE FROM INFORMATION_SCHEMA.[COLUMNS] WHERE TABLE_NAME = 'YourTableName' AND COLUMN_NAME = 'YourColumnName'
If it is DATE, DATETIME, DATETIME2, or SMALLDATETIME you are doing the right thing - don't do any changes to the table or the way the column is stored.If you want to query the table and get the result in the "20010701" format, do it like this:SELECT CONVERT(CHAR(8),YourColumn,112);
However, it would be better for a variety of reasons to not do this conversion in SQL - instead, simply query the column, send the result to the client (such as a presentation layer) and have the client do the necessary conversion. 
Datetime convert
Posted - 2012-05-07 : 07:11:56
