[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')