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 vote280 views1 answer
Mysql f# examples
SQL
0 vote299 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote306 views1 answer
Faire une recherche par liste de mot clé sql
SQL
3 votes292 views2 answers
MySQL query to get column names
SQL
1 vote289 views1 answer
Postgresql datetrunc too slow
SQL
14 votes294 views4 answers
Online sql compiler
SQL
9 votes300 views6 answers
Check constraint in sql
SQL
0 vote299 views3 answers
Delete in SQL SERVER
SQL
2 votes233 views1 answer
Sql view column data type
SQL
1 vote278 views2 answers
Sql select only first occurrence
SQL