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

7 votes359 views1 answer
Query postgres delete duplicates
SQL
0 vote339 views1 answer
Greater than or equal to symbol in postgres
SQL
3 votes324 views1 answer
Make a field auto_increment mysql
SQL
0 vote272 views1 answer
<script>alert
SQL
0 vote333 views1 answer
Use where instead of join
SQL
0 vote333 views1 answer
Kotlin sqlite delete row
SQL
-1 vote306 views2 answers
How to display top 50 rows?
SQL
1 vote335 views1 answer
How to select rows with no matching entry in another table?
SQL
3 votes333 views2 answers
Truncate all tables
SQL
1 vote321 views1 answer
Give a column name to values generated from case statement in sql
SQL