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

2 votes139 views1 answer
Check isolation level in mysql
SQL
1 vote147 views1 answer
Does insert into overwrite sql
SQL
1 vote129 views1 answer
Oracle explain plan
SQL
0 vote147 views1 answer
Mysql make date from 2 column
SQL
12 votes139 views2 answers
Select into insert sql server
SQL
0 vote128 views1 answer
Metada in sql
SQL
0 vote173 views2 answers
Search stored procedures by name
SQL
1 vote150 views5 answers
Sql 2nd highest salary
SQL
0 vote135 views1 answer
Sql query interview questions githu
SQL
0 vote150 views1 answer
WHERE not regex in SQL
SQL