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

# GETDATE

> Returns the query-start timestamp with microsecond precision.

<div className="e6-meta"><span className="e6-eyebrow e6-eyebrow--quiet">Scalar function</span></div>

**Aliases:** [`current_timestamp`](/query/sql/functions/date-time/current_timestamp)

The result is non-NULL.

## Syntax

### Getdate default (scalar)

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

## Arguments

Takes no arguments. Use CURRENT\_TIMESTAMP for the form that accepts a time zone.

## Returns

* Type: TIMESTAMP with a time zone
* NULL behavior: The result is non-NULL.

## Properties

| Property | Value |
| - | - |
| Deterministic | No |
| Exact result | Yes |

## Usage notes

* Deterministic: The time differs between queries but is fixed during each query.

## Examples

### Alias calling form: GETDATE

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT getdate() AS result;
```

Variable result: The value depends on the query start; repeated calls share that query's stored instant.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.