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

0 vote182 views1 answer
Hotw to alter lengh character vayng postgres
SQL
6 votes180 views2 answers
Join vs union
SQL
0 vote168 views1 answer
Mariadb search columns
SQL
0 vote196 views1 answer
Rails sql query converstion
SQL
1 vote260 views3 answers
Showing all columns in an sqlite table
SQL
18 votes172 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote174 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote189 views2 answers
Mysql missin expression near on
SQL
0 vote125 views1 answer
Mysql convert column to uppercase
SQL
8 votes163 views3 answers
Postgresql connection string c#
SQL