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

1 vote204 views1 answer
Sql list all procedures
SQL
1 vote207 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote200 views2 answers
Sql regex vowel
SQL
0 vote173 views1 answer
Big query add table rows to another table
SQL
2 votes208 views1 answer
Set username and password for postgresql database
SQL
0 vote196 views1 answer
Mysql two joins
SQL
5 votes200 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote225 views1 answer
How to set up a trigger in sql
SQL
0 vote188 views1 answer
Oracle execute package dblink
SQL
0 vote200 views1 answer
Get time component of datetime sql
SQL