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 vote116 views1 answer
How to drop function in sql
SQL
7 votes122 views1 answer
Buy forge mods server hosting
SQL
0 vote110 views1 answer
SQL server select to get sum of hours
SQL
1 vote121 views1 answer
Convert varchar to int in sqlite
SQL
0 vote114 views2 answers
Mysql create table if not exists
SQL
10 votes115 views3 answers
Insert into auto increment mysql
SQL
0 vote124 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote117 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote112 views1 answer
MySQL FIND_IN_SET()
SQL
5 votes150 views4 answers
Sql check
SQL