MSDN Authoring Template

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] It is worth noting that when you convert such dates with Style 130 (Kuwaiti or Hijri), converting to the char data type may result in the data corruption if the collation is not one of the Arabic ... ................
................