MSDN Authoring Template

The following example shows how the CONVERT function is used: SELECT CONVERT(char, GETDATE(), 100) AS [100] Aug 16 2000 11:50AM . You can then convert the data from a string to a date value in much the same manner: SELECT CONVERT(datetime, 'Aug 16 2000 11:50AM', 100) AS [100] ................
................