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

2 votes152 views1 answer
Mysql clear screen
SQL
0 vote142 views1 answer
Automate mysql cli query
SQL
8 votes146 views1 answer
Oracle find text in functions
SQL
2 votes150 views1 answer
Mysql sysdate - 1 day
SQL
0 vote149 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote146 views1 answer
List mysql tables and views
SQL
0 vote159 views1 answer
Intellij idea add mysql connector
SQL
3 votes160 views1 answer
Select database in sql
SQL
0 vote134 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote143 views1 answer
Insert or update cassandra
SQL