> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for CURRENT_TIMESTAMP function

# CURRENT_TIMESTAMP

Returns the current timestamp as a `TIMESTAMPTZ` value.

**Alias:** `NOW`

## Syntax

The function can be called with or without parentheses:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()
```

## Return Type

`TIMESTAMPTZ`

## Remarks

The function gets the current timestamp from the system, and returns it as a `TIMESTAMPTZ` value.

## Example

The following example assumes that the current Unix timestamp is `2023-03-03 14:42:31.123456 UTC`.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SET time_zone = 'Europe/Berlin';
SELECT CURRENT_TIMESTAMP;  --> 2023-03-03 15:42:31.123456+01

SET time_zone = 'America/New_York';
SELECT CURRENT_TIMESTAMP;  --> 2023-03-03 09:42:31.123456-05
```
