Insert current date sql

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

13 votes248 views2 answers
Check if value is null mysql
SQL
0 vote320 views1 answer
Oracle simple quote
SQL
8 votes272 views1 answer
My sql version
SQL
2 votes277 views2 answers
Mysql count rows returned
SQL
-1 vote262 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote277 views1 answer
Show mysql account privilleges
SQL
0 vote270 views1 answer
How to create a table based on another table in mysql
SQL
1 vote295 views2 answers
Drop table with constraints
SQL
0 vote255 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote261 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL