Description | The |
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 |