Time Zone - DST
My data base has time stamps in UTC but I work from Israel (UTC+2)
Hiw can I query my data in israel time intervals without having to manually "calculate" the daylight saving time
Here is an example of what I mean:
If I want to check the count of records in one of my tables entered between 27-Oct at 09:00 ISL to 29-OCt 09:00 ISL.
Currently I need to "remember" that in ISL the DST accurs on 28-OCT night so
First date in UTC terms is
27-Oct 07:00 until 28-Oct *08:00*
Is there any simple function that I can use?
Input - time in my own TZ
Requested Output - TZ in UTC (considering DST)
Thanks
Hiw can I query my data in israel time intervals without having to manually "calculate" the daylight saving time
Here is an example of what I mean:
If I want to check the count of records in one of my tables entered between 27-Oct at 09:00 ISL to 29-OCt 09:00 ISL.
Currently I need to "remember" that in ISL the DST accurs on 28-OCT night so
First date in UTC terms is
27-Oct 07:00 until 28-Oct *08:00*
Is there any simple function that I can use?
Input - time in my own TZ
Requested Output - TZ in UTC (considering DST)
Thanks
0
Answers
I used https://www.iana.org/time-zones db.