# NOW

| **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()                                                                                                                                                                                |

{% hint style="info" %}
There are no variables required for this function; it returns the current date and time.
{% endhint %}

{% hint style="success" %}
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.
{% endhint %}

## Example

### Table

| Transaction   | Sale Date           |
| ------------- | ------------------- |
| Transaction A | 2023-09-10 08:30:00 |
| Transaction B | 2023-08-25 15:15:00 |
| Transaction C | 2023-09-01 11:45:00 |

### Function

```
NOW()
```

### Results

| NOW (datetime)      |
| ------------------- |
| 2023-09-05 14:20:00 |
| 2023-09-05 14:20:00 |
| 2023-09-05 14:20:00 |
