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

8 votes116 views2 answers
Mysql query dates between two dates
SQL
0 vote123 views1 answer
Get clob size oracle
SQL
7 votes120 views2 answers
Phpmyadmin change password
SQL
9 votes147 views3 answers
Date format in sql
SQL
0 vote119 views1 answer
What is the use of index in mysql table
SQL
0 vote130 views1 answer
Oracle chain step succeeded
SQL
0 vote127 views1 answer
Sql check if column exists
SQL
1 vote129 views1 answer
How to print longest name in sql
SQL
0 vote123 views3 answers
Condition in count sql
SQL
3 votes113 views3 answers
Print in pl sql
SQL