Convert DateTime Data Type

(This example was done using SQL Query Analyzer in SQL Server 2000) Say you have this table below, product_type log_datetime xbox 2008-06-11 16:26:46.000 xbox 2008-06-13 16:30:09.653 psp 2008-06-14 16:28:08.000 ps 2008-06-16 16:21:40.000 And you would like to display log_datetime in different format, how do you do it? One way is to do the formating at Read more about Convert DateTime Data Type[…]