I have a DATETIME field which is in EEST timezone but once imported it shows as UTC. Let’s say in the original source it is 11:00:00 EEST, in Quicksight this will be shown as 11:00:00Z, so UTC, with no conversion (it would be 08:00:00Z).
I played a bit with parseDate and formatDate but I cannot find a way to create a calculated field to get the value in UTC unless I manually add / remove hours using addDatetime. I would like to avoid this though since DST would screw things up.
Is there any way to have the field converted properly without having to worry about DST changes?
I was thinking that using formatDate I could create a string with date, time and timezone, then use parseDate, but unfortunately time zone info is not in the list of supported formats.
As of now I cannot change settings on my MySQL instance.