Amazon Redshift introduces new data type to support time zones in time stamps

You can now use time zones as part of time stamps in Amazon Redshift. The new TIMESTAMPTZ data type allows you to input timestamp values that include a time zone. Amazon Redshift automatically converts timestamps to Coordinated Universal Time (UTC) and stores the UTC values. Also, the COPY command now recognizes timestamp values with time zones in the source data and automatically converts them to UTC.  You can retrieve and display timestamps in Amazon Redshift by setting your preferred time zone at the session level, user level or client connection level.  
Quelle: aws.amazon.com

Published by