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

4 votes198 views2 answers
Error loading MySQLdb module.
SQL
0 vote206 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote177 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote202 views2 answers
Nested query
SQL
0 vote186 views1 answer
Mysql jdbc timezone
SQL
0 vote189 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote164 views2 answers
Sql update from two different database
SQL
0 vote199 views4 answers
How to get max salary in each department in sql
SQL
3 votes207 views2 answers
Oracle drop column
SQL
0 vote227 views2 answers
Sql query print strings and int
SQL