Get current date sql

SELECT getdate(); -- Get Current date in SQL Server

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

Sql display today's date

SELECT getdate()

Sql current date

Add GETDATE() in sql query where you want to pass current timestamp.

Example
Return the current database system date and time:

SELECT GETDATE();

Current date in sql

SELECT CURRENT_DATE from dual;

Similar codes

1 vote141 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote151 views1 answer
Sql not exists
SQL
0 vote163 views1 answer
Postgres full text search example
SQL
3 votes131 views2 answers
Pl sql escape '
SQL
0 vote139 views1 answer
Oracle sql winter time change
SQL
1 vote149 views1 answer
Sql week commencing date
SQL
0 vote163 views1 answer
Create dabase postgresql
SQL
0 vote138 views1 answer
Do postgresql
SQL
-1 vote165 views5 answers
Operator in sql
SQL
0 vote162 views1 answer
Database db connection string format
SQL