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

4 votes414 views2 answers
Postgresql float data type
SQL
0 vote363 views1 answer
Sql query to return field name of a table
SQL
1 vote352 views1 answer
Python clean sql string
SQL
0 vote338 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote363 views1 answer
Resullt all update knex mysql
SQL
0 vote352 views1 answer
Get the previous column of a table in mysql
SQL
20 votes351 views3 answers
SQL query rename table
SQL
0 vote356 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
1 vote340 views1 answer
Sql group by error
SQL
6 votes355 views2 answers
If not exists insert sql
SQL