1

Our Redshift cluster seems to be returning timestamps in the local timezone (Pacific/Auckland) instead of UTC even though the AWS docs say:

GETDATE returns the current date and time in UTC

eg:

select GETDATE();

2016-08-30 10:22:18.000000

should return:

2016-08-29 22:22:18.000000
Mikey
  • 23
  • 1
  • 5

1 Answers1

0

Redshift wasn't returning dates in localtime at all; my IDE was translating all dates to localtime.

I'm using PHPStorm's database console. Unfortunately there's no way to disable the timezone translation, the best you can do is change PHPStorm's timezone to UTC but that will affect all date related features of the IDE.

Community
  • 1
  • 1
Mikey
  • 23
  • 1
  • 5