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

0 vote183 views1 answer
Mysql relationships between tables
SQL
0 vote144 views1 answer
Mysql workbench format date
SQL
2 votes191 views1 answer
Username sql
SQL
0 vote146 views1 answer
How to set all the min and sec data to zero in sql server
SQL
2 votes134 views1 answer
Mysql auto increment jumping
SQL
1 vote156 views1 answer
Sql select row with max date
SQL
2 votes147 views1 answer
Compare date in sql
SQL
0 vote163 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
3 votes157 views1 answer
Select table column in sql
SQL
0 vote149 views1 answer
Sql find all different values in column
SQL