SQL
Timestamp Types
| Name | Aliases | Description |
|:---|:---|:---|
| `TIMESTAMP_NS` |                            | timestamp with nanosecond precision (ignores time zone)  |
| `TIMESTAMP`    | `DATETIME`                 | timestamp with microsecond precision (ignores time zone) |
| `TIMESTAMP_MS` |                            | timestamp with millisecond precision (ignores time zone) |
| `TIMESTAMP_S`  |                            | timestamp with second precision (ignores time zone)      |
| `TIMESTAMPTZ`  | `TIMESTAMP WITH TIME ZONE` | timestamp (uses time zone)                               |  
A timestamp specifies a combination of [`DATE`](#docs:sql:data_types:date) (year, month, day) and a [`TIME`](#docs:sql:data_types:time) (hour, minute, second, microsecond). Timestamps can be created using the `TIMESTAMP` keyword, where the data must be formatted according to the ISO 8601 format (` YYYY-MM-DD hh:mm:ss[.zzzzzz][+-TT[:tt]]`). Decimal places beyond the targeted sub-second precision are ignored.  
> **Warning.  ** When defining timestamps using a `TIMESTAMP_NS` literal, the decimal places beyond _microseconds_ are ignored. Note that the `TIMESTAMP_NS` type is able to hold nanoseconds when created e.g., via the ingestion of Parquet files.  
```sql
SELECT TIMESTAMP_NS '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00.123456
```  
```sql
SELECT TIMESTAMP '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00.123456
```  
```sql
SELECT DATETIME '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00.123456
```  
```sql
SELECT TIMESTAMP_MS '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00.123
```  
```sql
SELECT TIMESTAMP_S '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00
```  
```sql
SELECT TIMESTAMPTZ '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00.123456+00
```  
```sql
SELECT TIMESTAMP WITH TIME ZONE '1992-09-20 11:30:00.123456789';
```  
```text
1992-09-20 11:30:00.123456+00
```