Insert current date sql

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 vote174 views1 answer
Capabilities of sql select statements
SQL
2 votes127 views2 answers
Created at and updated at in mysql
SQL
0 vote119 views3 answers
Joins and views sql
SQL
0 vote135 views1 answer
Drop all triggers oracle
SQL
2 votes130 views1 answer
Oracle list duplicates
SQL
1 vote146 views2 answers
Mysql switch case
SQL
-2 votes137 views2 answers
Union vs union all in sql
SQL
15 votes127 views1 answer
Mysql int range
SQL
0 vote119 views1 answer
Increment id in mysql
SQL
18 votes133 views4 answers
Uninstall mysql on ubuntu
SQL