Category: SQL Server 2000

(This example was done using SQL Query Analyzer in SQL Server 2000)

Say you have this table below,

And you would like to display log_datetime in different format, how do you do it? One way is to do the formating at the query side. Example, if you want the date format to be dd mmm yyyy format, use CONVERT to format log_datetime like below

SELECT product_type, convert(varchar(11),log_datetime,106) AS log_date FROM test ORDER BY log_datetime

The output becomes,

If you want to just show the time only, just change the 106 to 108 to become,

SELECT product_type, convert(varchar(11),log_datetime,108) AS log_date FROM test ORDER BY log_datetime

The output becomes,

For more reference, http://doc.ddart.net/mssql/sql70/ca-co_1.htm