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

0 vote208 views1 answer
Create dabase postgresql
SQL
3 votes250 views3 answers
Mysql declare variable
SQL
-1 vote243 views1 answer
Mysql change database charset and collation
SQL
0 vote237 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote192 views1 answer
Sql count how many times a value appears
SQL
12 votes239 views4 answers
How to take database dump in postgresql
SQL
0 vote274 views1 answer
Look at running processes redshift
SQL
0 vote260 views2 answers
Compound operator in sql
SQL
22 votes262 views4 answers
Date format mysql
SQL
21 votes232 views3 answers
Average sql
SQL