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 vote378 views1 answer
Prisma transaction
SQL
0 vote354 views1 answer
Get enginge db mysql
SQL
0 vote345 views2 answers
How to use aggregate functions in sql
SQL
0 vote356 views1 answer
Ms sql print more than 1 variable
SQL
0 vote331 views1 answer
How to to get current date and time in sql
SQL
1 vote363 views3 answers
Showing all columns in an sqlite table
SQL
0 vote352 views1 answer
Search column name sql
SQL
1 vote348 views1 answer
Snowflake rename column name
SQL
0 vote389 views2 answers
Unique key
SQL
0 vote352 views1 answer
Java nosql sort
SQL