SQL NOW()
Function
NOW() Function
The NOW() function returns the current system date and time.
SQL NOW() Syntax
Demo Database
In this tutorial, we will use the tutorialpro sample database.
Below are the data from the "Websites" table:
+----+--------------+---------------------------+-------+---------+
| id | name | url | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | tutorialpro.org | http://www.tutorialpro.org/ | 4689 | CN |
| 4 | Weibo | http://weibo.com/ | 20 | CN |
| 5 | Facebook | https://www.facebook.com/ | 3 | USA |
| 7 | Stackoverflow | http://stackoverflow.com/ | 0 | IND |
+----+---------------+---------------------------+-------+---------+
SQL NOW() Example
The following SQL statement selects the name, url, and current date from the "Websites" table:
Example
Executing the above SQL outputs the following results: