How do you compare a timestamp with a timezone with a timestamp in postgresql? I am trying to cast one of the 2 to the type of the other but it does not work for me. Eg.
TS1: 2019-01-07 21:43:00
TS2: 2019-01-07 20:43:37+01
I need to compare them and check if they are the same not including the seconds. So I have tried with:
select attimestamp, attimestamp_tz, attimestam=attimestamp_tz::timestamp from attendance where atid=1070
but this will always return false.