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 vote336 views1 answer
Local sql server
SQL
0 vote306 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote353 views1 answer
Create schema sql server
SQL
1 vote336 views1 answer
Clear screen command in psql
SQL
19 votes347 views6 answers
Sql server drop table if exists
SQL
0 vote363 views3 answers
Database restoring error
SQL
0 vote346 views1 answer
Mysql root localhost run
SQL
2 votes338 views2 answers
Mysql on duplicate key ignore
SQL
0 vote333 views1 answer
Create api project in visual studio 2019 and sql server
SQL
5 votes326 views2 answers
Oracle to_timestamp
SQL