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 vote150 views1 answer
Mitigation of sql injection
SQL
0 vote186 views1 answer
What are the aggregate function in sql
SQL
4 votes205 views2 answers
Sql table
SQL
22 votes226 views3 answers
How to join three tables in sql using joins
SQL
0 vote199 views1 answer
Oracle create package specification
SQL
0 vote221 views1 answer
Oracle 11g forget password
SQL
0 vote208 views1 answer
Show table details postgresql
SQL
4 votes205 views1 answer
Postgresql create table with index
SQL
0 vote224 views1 answer
Drop a view in sqlite
SQL
2 votes203 views1 answer
Oracle number to percentage
SQL