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

16 votes179 views6 answers
Python sqlite
SQL
1 vote213 views2 answers
Install sql server management studio ubuntu
SQL
0 vote189 views1 answer
Sql find gaps in date ranges
SQL
1 vote186 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
4 votes167 views4 answers
Update select mysql
SQL
0 vote178 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote189 views1 answer
QUERY JPQL
SQL
1 vote172 views2 answers
Sql multiline comment
SQL
0 vote158 views1 answer
How to find the most occuring in SQL
SQL
1 vote173 views1 answer
Oracle undo usage per session
SQL