PARSE SQL Server Example

SQL Server > Built-in Functions > PARSE

Translates an expression to the requested data type.

Example

SELECT PARSE('3-11-2014' AS datetime USING 'en-US') AS Result_En

Result_En

2014-03-11 00:00:00.000

SELECT PARSE('3-11-2014' AS datetime USING 'de-DE') AS Result_De

Result_De

2014-11-03 00:00:00.000