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 vote313 views2 answers
Datetrunc hour snowflake
SQL
0 vote364 views1 answer
Check command
SQL
2 votes312 views1 answer
Add default sql server
SQL
16 votes346 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote322 views1 answer
Copy value from one column to another postgres
SQL
3 votes306 views2 answers
Pl sql escape '
SQL
1 vote333 views2 answers
Postgres select from last 3 months
SQL
1 vote291 views2 answers
How to drop a unique constraint in sql
SQL
24 votes342 views6 answers
Replace mysql
SQL
1 vote330 views1 answer
Where database run
SQL