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
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
I assume you're talking about the extract stage before connecting the data to Tableau?!
If so, which database and language are you using? I don't recognize the ::date syntax, in Tableau it would be DATE()