Easy Tutorial
❮ Sql Join Left Func Date ❯

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:

❮ Sql Join Left Func Date ❯