NOW

Retrieves the current date and time

Updated over a week ago

Description

The NOW() function provides the current date and time at the moment it is called. This is useful for timestamping records, scheduling events, or calculating time differences.

Syntax

NOW()

Output

datetime

There are no variables required for this function; it returns the current date and time.

In the dataset, a single datetime value is appended to all rows irrespective of the table's processing time. This value corresponds to the timestamp at the beginning of the NOW() function's execution.

Example

Transaction

Sale Date

NOW()

Transaction A

2023-09-10T04:30:00000-04:00

2023-10-09T09:40:07931-04:00

Transaction B

2023-08-25T11:15:00000-04:00

2023-10-09T09:40:07931-04:00

Transaction C

2023-09-01T07:45:00000-04:00

2023-10-09T09:40:07931-04:00

Did this answer your question?