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

11 votes129 views2 answers
Insert current date sql
SQL
0 vote131 views1 answer
Get time component of datetime sql
SQL
0 vote136 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote135 views1 answer
Oracle to_number
SQL
23 votes132 views1 answer
How remove column in mysql
SQL
0 vote140 views1 answer
Count database access django
SQL
1 vote129 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote129 views1 answer
Oracle create table auto generated primary key
SQL
1 vote123 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote125 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL