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 vote216 views1 answer
Sql server size of every table in a db
SQL
1 vote225 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote219 views1 answer
Get number of rows in every table mysql
SQL
0 vote210 views1 answer
Mysql select last 15 minutes
SQL
0 vote211 views1 answer
Sql server split string and insert into table select
SQL
3 votes205 views1 answer
What is having clause
SQL
1 vote210 views1 answer
Oracle index partition
SQL
2 votes222 views1 answer
Datetrunc
SQL
3 votes220 views1 answer
Mysql replace string in table
SQL
22 votes227 views3 answers
SQL CHEATSHEET
SQL