NOW

MySQL

NOW()

Example

SELECT NOW() as CurrentDateAndTime;

Output

+---------------------------+
| CurrentDateAndTime        |
+---------------------------+
| 2022-05-25 13:31:20       |
+---------------------------+

Explanation

The NOW() function in SQL returns the current date and time. This function is commonly used to record the time of an event.

PostgreSQL

NOW() RETURNS TIMESTAMP WITH TIME ZONE

Example

SELECT NOW();

Output

2021-06-01 13:20:40.927052+00

Explanation

The NOW() function in PostgreSQL is utilized to return the current date and time with timezone. The returned timestamp includes the date, hours, minutes, seconds, and milliseconds. This function could be utilized whenever the current date and time is required in database operations.

Oracle

NOW()

Example

SELECT NOW() FROM dual;

Output

"2022-09-22 12:34:56"

Explanation

The above SQL statement uses the NOW() function to retrieve the current date and time from the Oracle server. It is selecting from dual, which is a system table in Oracle that always exists, always has exactly one row, and always has exactly one column. This is often used when there is no relevant table to select from, such as when calling functions like NOW().