We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Time Zone - DST — Vertica Forum

Time Zone - DST

MaorFridMaorFrid
in General Discussion
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

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...