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 vote348 views1 answer
Alter table add check constraint oracle
SQL
11 votes341 views3 answers
Sql_mode=only_full_group_by
SQL
6 votes318 views1 answer
Check Table Exists
SQL
15 votes339 views4 answers
Export mysql db using command line
SQL
1 vote342 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote318 views1 answer
Check if table exists oracle
SQL
0 vote327 views1 answer
Create database store
SQL
0 vote323 views1 answer
Select odd records sql
SQL
0 vote334 views1 answer
Can we rollback in sql
SQL
1 vote474 views3 answers
Uninstall postgresql mac
SQL