-- return the datetime in various formats
 SELECT CONVERT(VARCHAR(10),GETDATE(),09) AS query_one
 SELECT CONVERT(VARCHAR(11),GETDATE(),106) AS query_two
 SELECT CONVERT(VARCHAR(8),GETDATE(),112) AS query_three
 SELECT CONVERT(VARCHAR(24),GETDATE(),113) AS query_four