> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/date-and-time/localtimestamp",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for LOCALTIMESTAMP function

# LOCALTIMESTAMP

Returns the current local timestamp in the time zone specified in the session's [`timezone` setting](/reference-sql/system-settings#setting-the-time-zone).

## Syntax

The function can be called with or without parentheses:

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

## Return Type

`TIMESTAMP`

## Remarks

The function gets the current timestamp from the system, converts it to the time zone specified in the `timezone` setting, and returns it as a `TIMESTAMP` value.

## Example

The following example assumes that the current timestamp is `2023-03-03 14:42:31.123456 UTC`.
Observe how it returns different `TIMESTAMP` values for different time zone settings:

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

SET timezone = 'America/New_York';
SELECT LOCALTIMESTAMP;  --> 2023-03-03 09:42:31.123456
```