Create date sql

-- SQL Server
SELECT cast(cast(@year*10000 + @month*100 + @day as varchar(255)) as date)
-- Oracle:TO_DATE(string, format)
SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual;
SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual;
-- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes.
SELECT datefromparts(@year, @month, @day)
SELECT CONVERT(DATETIME, '2012-06-05', 102);	  -- Raises error if impossible
SELECT TRY_CONVERT(DATETIME, '2012-06-05', 102);  -- Returns Null if impossible
-- MySQL: STR_TO_DATE(string, format): 
SELECT STR_TO_DATE('2012-06-05','%Y-%m-%d');

Similar codes

22 votes148 views6 answers
Create sql table
SQL
0 vote130 views1 answer
Sql view index
SQL
0 vote149 views1 answer
Oracle sql date winter time
SQL
0 vote174 views1 answer
SQL Server Enterprise
SQL
1 vote145 views1 answer
Sql current timestamp
SQL
0 vote135 views1 answer
2020 new year
SQL
-3 votes136 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote141 views5 answers
Mode sql course
SQL
8 votes138 views1 answer
Oracle find text in functions
SQL
18 votes135 views4 answers
Foreign key mySql
SQL