SQL Server: convert a string to a date Jul 22, 2016 Simple but useful snippet for converting a string to a date using a specific locale in SQL Server: TRY_PARSE('22/07/2016' AS DATETIME USING 'fr-fr')