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 vote332 views1 answer
Drop primary key oracle
SQL
0 vote354 views1 answer
Osm2pgsql mac
SQL
3 votes300 views2 answers
Monthname sql
SQL
0 vote303 views4 answers
Forenkey code alchemy sql
SQL
2 votes300 views1 answer
Columns Present in a table
SQL
0 vote299 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
4 votes313 views6 answers
Sql select statement
SQL
1 vote297 views1 answer
Oracle split string
SQL
23 votes297 views3 answers
Mysqldump
SQL
0 vote310 views1 answer
Mysql calculated column
SQL