Time Zone - DST

MaorFridMaorFrid Registered User
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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file