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

9 votes237 views4 answers
Last mysql
SQL
0 vote256 views1 answer
Get only one row in mysql
SQL
1 vote250 views1 answer
Sqlalchemy order by descending
SQL
0 vote239 views1 answer
Postgresql print variable
SQL
5 votes255 views1 answer
Get column name sql server
SQL
0 vote298 views1 answer
What is common table expression in sql
SQL
-1 vote254 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
8 votes266 views1 answer
Mysql limit rows
SQL
0 vote234 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote230 views1 answer
Wordpress change url phpmyadmin
SQL