Insert date sql

INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));

Insert current date sql

INSERT INTO my_table (last_updated) VALUES(NOW());
INSERT INTO my_table (last_updated) VALUES(sysdate);	-- Oracle
INSERT INTO my_table (last_updated) VALUES(getdate());	-- SQL Server

Similar codes

0 vote326 views1 answer
Compare field sql server
SQL
2 votes319 views1 answer
Cast string to datetime mysql
SQL
1 vote280 views1 answer
Firebase bigquery cloud message
SQL
0 vote287 views1 answer
Check index sql server
SQL
0 vote272 views1 answer
Count column of tables psql
SQL
0 vote320 views1 answer
Set Mamp mysql globally
SQL
0 vote301 views1 answer
Postgresql regular expression special characters
SQL
1 vote314 views1 answer
Oracle stop
SQL
0 vote310 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote299 views1 answer
Export partttion and import in oracle
SQL