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

19 votes121 views6 answers
Sql server drop table if exists
SQL
0 vote123 views2 answers
How to delete the rows with null values in mysql
SQL
-1 vote119 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote116 views1 answer
Oracle DROP PROGRAM
SQL
0 vote107 views2 answers
Nosqlbooster query other collection
SQL
1 vote107 views2 answers
Difference between in and between in sql
SQL
2 votes141 views1 answer
Datefromparts mssql
SQL
0 vote127 views1 answer
Compare subqueries oracle
SQL
16 votes121 views2 answers
Oracle ddl
SQL
1 vote114 views1 answer
Primary key reset in SQL database
SQL