Nov 21, 2014

[Tips] Database convert to date

Oracle SELECT to_date('01-JAN-2014', 'dd.MM.yyyy') FROM dual
SQL Server SELECT CAST('01-JAN-2014' AS DATE)
SQL Server SELECT CONVERT(DATE,'01/JAN/2014')

0 comments: