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

0 vote91 views1 answer
Select value from previous row in postgresql
SQL
0 vote103 views1 answer
Mysql streaming example
SQL
6 votes106 views2 answers
Mysql first day of month
SQL
0 vote69 views1 answer
Expose db in virtualbox
SQL
2 votes108 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote108 views1 answer
Oracle drop default value
SQL
0 vote113 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote104 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote104 views1 answer
Run postgresql dump to csv
SQL
1 vote106 views1 answer
Default
SQL