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

7 votes221 views2 answers
Sql remove duplicates based on column
SQL
0 vote187 views1 answer
Convert .mdf to .bak
SQL
0 vote171 views1 answer
Mysql database is not starting in xampp
SQL
7 votes193 views2 answers
N highest salary in sql
SQL
0 vote196 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote217 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote191 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote210 views1 answer
How to print sql query
SQL
0 vote199 views3 answers
Sql query checker
SQL
0 vote181 views3 answers
Joins and views sql
SQL