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

5 votes187 views3 answers
Mysql extract month from date
SQL
0 vote189 views1 answer
Select row with latest date mysql
SQL
0 vote176 views1 answer
Optimize sql query
SQL
0 vote190 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
1 vote174 views1 answer
Operator does not exist: integer = text
SQL
0 vote270 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
10 votes182 views4 answers
Inner join in update query mysql
SQL
1 vote209 views1 answer
Sql row having max
SQL
3 votes195 views2 answers
Oracle drop column
SQL
6 votes191 views2 answers
What is non relational database
SQL