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

1 vote108 views1 answer
Postgres reset auto increment
SQL
61 votes1.1K views6 answers
Mysql add column
SQL
0 vote209 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote204 views1 answer
Mysql sort by date column
SQL
1 vote169 views1 answer
Sql select table header
SQL
0 vote159 views2 answers
Py sqlite if entry exists
SQL
13 votes227 views4 answers
Mysql remove foreign key constraint
SQL
14 votes168 views3 answers
How to add default constraint in mysql
SQL
23 votes163 views3 answers
Sql where contains part of string
SQL
5 votes165 views3 answers
Mysql update field from one table to another
SQL