Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
When I use Join recipe to join two Redshift tables in DSS, it automatically applies time zone conversion to date field:
You can set up the time zone for the dataset in its setting, but the conversion stays there even thought it actually does nothing. โ
Is there a setting that suppresses (removes) the conversion altogether ?
Operating system used: Windows 10
Hi,
unless the column in the input table is typed as a timestamp, there's no way to avoid the conversion. We'll look into suppressing when both origin and destination timezones are UTC.
Hi,
unless the column in the input table is typed as a timestamp, there's no way to avoid the conversion. We'll look into suppressing when both origin and destination timezones are UTC.