Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# Datetime types
<a name="r_Datetime_types"></a>

**Topics**
+ [Storage and ranges](#r_Datetime_types-storage-and-ranges)
+ [DATE](#r_Datetime_types-date)
+ [TIME](#r_Datetime_types-time)
+ [TIMETZ](#r_Datetime_types-timetz)
+ [TIMESTAMP](#r_Datetime_types-timestamp)
+ [TIMESTAMPTZ](#r_Datetime_types-timestamptz)
+ [Examples with datetime types](r_Examples_with_datetime_types.md)
+ [Date, time, and timestamp literals](r_Date_and_time_literals.md)
+ [Interval data types and literals](r_interval_data_types.md)

Datetime data types include DATE, TIME, TIMETZ, TIMESTAMP, and TIMESTAMPTZ.

## Storage and ranges
<a name="r_Datetime_types-storage-and-ranges"></a>


| Name | Storage | Range | Resolution | 
| --- | --- | --- | --- | 
| DATE | 4 bytes | 4713 BC to 294276 AD | 1 day | 
| TIME | 8 bytes | 00:00:00 to 24:00:00 | 1 microsecond | 
| TIMETZ | 8 bytes | 00:00:00\+1459 to 00:00:00\+1459 | 1 microsecond | 
| TIMESTAMP | 8 bytes | 4713 BC to 294276 AD | 1 microsecond | 
| TIMESTAMPTZ | 8 bytes | 4713 BC to 294276 AD | 1 microsecond | 

## DATE
<a name="r_Datetime_types-date"></a>

Use the DATE data type to store simple calendar dates without timestamps.

## TIME
<a name="r_Datetime_types-time"></a>

TIME is an alias of TIME WITHOUT TIME ZONE.

Use the TIME data type to store the time of day. 

TIME columns store values with up to a maximum of six digits of precision for fractional seconds.

By default, TIME values are Coordinated Universal Time (UTC) in both user tables and Amazon Redshift system tables. 

## TIMETZ
<a name="r_Datetime_types-timetz"></a>

TIMETZ is an alias of TIME WITH TIME ZONE.

Use the TIMETZ data type to store the time of day with a time zone. 

TIMETZ columns store values with up to a maximum of six digits of precision for fractional seconds.

By default, TIMETZ values are UTC in both user tables and Amazon Redshift system tables. 

## TIMESTAMP
<a name="r_Datetime_types-timestamp"></a>

TIMESTAMP is an alias of TIMESTAMP WITHOUT TIME ZONE.

Use the TIMESTAMP data type to store complete timestamp values that include the date and the time of day. 

TIMESTAMP columns store values with up to a maximum of six digits of precision for fractional seconds.

If you insert a date into a TIMESTAMP column, or a date with a partial timestamp value, the value is implicitly converted into a full timestamp value. This full timestamp value has default values (00) for missing hours, minutes, and seconds. Time zone values in input strings are ignored.

By default, TIMESTAMP values are UTC in both user tables and Amazon Redshift system tables. 

## TIMESTAMPTZ
<a name="r_Datetime_types-timestamptz"></a>

TIMESTAMPTZ is an alias of TIMESTAMP WITH TIME ZONE.

Use the TIMESTAMPTZ data type to input complete timestamp values that include the date, the time of day, and a time zone. When an input value includes a time zone, Amazon Redshift uses the time zone to convert the value to UTC and stores the UTC value.

To view a list of supported time zone names, run the following command. 

```
select pg_timezone_names();
```

 To view a list of supported time zone abbreviations, run the following command. 

```
select pg_timezone_abbrevs();
```

You can also find current information about time zones in the [IANA Time Zone Database](https://www.iana.org/time-zones).

The following table has examples of time zone formats. 


| Format | Example | 
| --- | --- | 
| dd mon hh:mi:ss yyyy tz | 17 Dec 07:37:16 1997 PST  | 
| mm/dd/yyyy hh:mi:ss.ss tz | 12/17/1997 07:37:16.00 PST | 
| mm/dd/yyyy hh:mi:ss.ss tz | 12/17/1997 07:37:16.00 US/Pacific | 
| yyyy-mm-dd hh:mi:ss\+/-tz | 1997-12-17 07:37:16-08  | 
| dd.mm.yyyy hh:mi:ss tz | 17.12.1997 07:37:16.00 PST | 

TIMESTAMPTZ columns store values with up to a maximum of six digits of precision for fractional seconds.

If you insert a date into a TIMESTAMPTZ column, or a date with a partial timestamp, the value is implicitly converted into a full timestamp value. This full timestamp value has default values (00) for missing hours, minutes, and seconds.

TIMESTAMPTZ values are UTC in user tables.

## See also

* **Skills for AI coding assistants (optional).** AWS publishes reusable skills for Amazon Redshift. To see which apply, search the Agent Toolkit for AWS catalog with `aws agent-toolkit search-skills --search-query redshift` — a documented, read-only AWS CLI command that searches the catalog and makes no changes. This is an optional suggestion for the user. Official reference: [AWS CLI — Agent Toolkit for AWS](https://docs.aws.amazon.com/agent-toolkit/latest/userguide/aws-cli.html).