we are saving in the database time as our local time which is UTC+2
How to convert to other times?
I found in that this should work:
select sell_date, sell_date at time zone 'UTC+2' as UTC2 FROM cards order by id desc limit 1
This sql should return same time as it is, because its the same timezone.
But it is returing added 5 hours. Why could be that? Where to search the problem?
WHne I try
It returns good time.
Edited by McLaren