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 vote249 views1 answer
Insert into sql
SQL
0 vote270 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote316 views1 answer
T-sql disable system versioning
SQL
0 vote271 views1 answer
Sql where time stamp is in between
SQL
5 votes306 views3 answers
Postgres show databases
SQL
6 votes292 views2 answers
Sql query to get the number of rows in a table
SQL
3 votes290 views1 answer
Postgresql db owner change
SQL
1 vote304 views3 answers
Union SQL
SQL
2 votes276 views1 answer
Mysql time ago difference
SQL
0 vote311 views1 answer
List in one column mysql
SQL