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

3 votes232 views4 answers
Sql interview questions
SQL
0 vote153 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote156 views1 answer
SELECT statement to find the specific cell in database table
SQL
10 votes146 views4 answers
Mysql one week ago
SQL
0 vote144 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote149 views1 answer
ALV GRID events
SQL
-1 vote157 views1 answer
Capitole toulouse
SQL
0 vote146 views1 answer
How to create a new shema using query languaage
SQL
0 vote158 views1 answer
Mysql aspas simples
SQL
0 vote154 views1 answer
Xamarin sql lite create table if not exist
SQL