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 vote118 views1 answer
Delete specific row in sql
SQL
0 vote112 views1 answer
Mssql describe stored procedure sqlcmd
SQL
1 vote97 views1 answer
Too many connections mysql
SQL
0 vote116 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
3 votes226 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote98 views1 answer
Excute raw query
SQL
0 vote101 views1 answer
Check connections to database postgres
SQL
1 vote100 views1 answer
Clear screen command in psql
SQL
6 votes103 views3 answers
Oracle all dates between two dates
SQL
1 vote93 views1 answer
How to delete record sql delphi
SQL