Current date sql

Mysql current date

In MySQL the CURDATE() returns the current date in 'YYYY-MM-DD' format or 'YYYYMMDD' format depending on whether numeric or string is used in the function. CURRENT_DATE and CURRENT_DATE() are the synonym of CURDATE()

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

11 votes273 views4 answers
MYSQL LOGIN
SQL
0 vote253 views1 answer
Select only one row sql
SQL
0 vote274 views1 answer
Get who is hired in month in sql
SQL
1 vote243 views1 answer
MySQL AND Operator
SQL
0 vote282 views1 answer
Hashpass
SQL
1 vote440 views1 answer
Postgres upgrade to superuser
SQL
0 vote277 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote321 views1 answer
Sql server query all database objects
SQL
3 votes304 views2 answers
Truncate table
SQL
11 votes270 views2 answers
Turn off safe mode mysql
SQL