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 vote301 views1 answer
Spring postgresql reset auto increment to 0
SQL
18 votes299 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote278 views1 answer
Go install mysql
SQL
4 votes316 views3 answers
Sql drop database if exists
SQL
1 vote311 views1 answer
Postgresql append array
SQL
0 vote324 views1 answer
Sql date with year
SQL
1 vote311 views1 answer
Mysql return if it contains
SQL
0 vote285 views1 answer
Postgresql array to rows
SQL
2 votes294 views1 answer
Columns Present in a table
SQL
2 votes282 views1 answer
Oracle log files
SQL