{"id":1539,"date":"2018-07-21T04:26:49","date_gmt":"2018-07-21T11:26:49","guid":{"rendered":"https:\/\/sqltutorial.org\/?page_id=1539"},"modified":"2020-04-04T06:56:16","modified_gmt":"2020-04-04T13:56:16","slug":"sql-current_timestamp","status":"publish","type":"page","link":"https:\/\/www.sqltutorial.org\/sql-date-functions\/sql-current_timestamp\/","title":{"rendered":"SQL CURRENT_TIMESTAMP"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to get the current date and time by using the SQL CURRENT_TIMESTAMP<\/code> function.<\/p>\n\n\n\n

To get the current date and time of the database server, you use the SQL CURRENT_TIMESTAMP<\/code> function as shown below:<\/p>\n\n\n

CURRENT_TIMESTAMP\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The CURRENT_TIMESTAMP<\/code> function is a SQL-standard function supported by almost all database systems such as DB2, Firebird, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and SQLite.<\/p>\n\n\n\n
The following statement returns the current date and time of the database server:<\/p>\n\n\n
SELECT<\/span> CURRENT_TIMESTAMP<\/span> \n        AS<\/span> 'Current date and time'<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n
Current date and time\n-----------------------<\/span>\n2018-07-21 18:12:42.023\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Note that in Oracle, you need to add the FROM dual<\/code> clause as shown below:<\/p>\n\n\n
SELECT<\/span> \n    CURRENT_TIMESTAMP<\/span> \n        AS<\/span> 'Current date and time'<\/span>\nFROM<\/span> \n    dual;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The CURRENT_TIMESTAMP<\/code> is often used to set a default value for a DATETIME<\/code> or a TIMESTAMP<\/code> column of a table.<\/p>\n\n\n\n
For example, the following statement creates a new table<\/a> that has the created_at<\/code> column which accepts the date and time as the default value.<\/p>\n\n\n
CREATE<\/span> TABLE<\/span> posts(\n    id<\/span> INT<\/span> PRIMARY KEY<\/span>,\n    title VARCHAR<\/span>(255<\/span>) NOT<\/span> NULL<\/span>,\n    created_at DATETIME DEFAULT<\/span> CURRENT_TIMESTAMP<\/span>\n);\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Whenever you insert a row into the posts table without specifying the value for the created_at<\/code> column, the database system will use the current date and time for that column as shown in the following statement:<\/p>\n\n\n
INSERT<\/span> INTO<\/span> posts(id<\/span>,title)\nVALUES<\/span>(1<\/span>,'SQL CURRENT_TIMESTAMP test'<\/span>);\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Let’s check the content of the posts<\/code> table:<\/p>\n\n\n
SELECT<\/span> * FROM<\/span> posts;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The following shows the output:<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
In this tutorial, you have learned how to use the SQL CURRENT_TIMESTAMP<\/code> function to get the current date and time of the database server.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t