1 Reply Latest reply on Jul 20, 2016 4:24 AM by Mark Fraser

    Timezone issues?

    Hannah Williams

      Good Morning

      I am having issues with timezones when I set a date time timestamp to just be date.

       

      This query below gives me correct results in tableau:

       

      select "timeStamp" AT TIME ZONE 'EDT', "statistic_data_id" as searchCount
      from table_a

       

      But I want just the date portion of the timestamp, because I'm joining on date to other tables. However When I try the below, the timezone is inaccurate.

       

      select "timeStamp"::date AT TIME ZONE 'EDT', "statistic_data_id" as searchCount
      from table_a

       

      any ideas?

       

      Thanks