Alert timestamps in database off by 4 hours

[Detroiter]

I just upgraded to 11.5 (yeah I know...) and I am seeing odd behavior in the new alert database tables.  I seems they are not using the local server time for the timestamp of when an alert occurred.  Screenshots below of a volume alert that occurred shortly before 9:30 am today (3/23)

Both images show the same alert, but the "All Active Alerts" page in Orion seems to be automatically converting them back to the correct time.  I use many custom SQL queries to report out on alert status and time is a critical component of them.  As is stands, if an alert triggered at 11 pm tonight, my daily report of alerts triggered for today WOULD NOT show it since the database would stamp it as 3 am TOMORROW.

Is this by design, if so WHY? 

[LadaVarga]

Hello,

We store time in DB in UTC.

You have to change your queries

I recommended use one of function from this page:

sql - Convert Datetime column from UTC to local time in select statement - Stack Overflow

After changing timezone you will only change one number in function.

I recommended use this one:

-Name: udfToLocalTime.sql
--Purpose: To convert UTC to local US time accounting for DST
--Author: Patrick Slesicki
--Date: 3/25/2014

Simple change from ALTER nameoffunction to CREATE nameoffuction.

Lada

[cahunt]

So your 4 hours off UTC?

[adatole]

HEY!!! No beating me to the big reveal!!

[cahunt]

Sorry, I wore my cape today!

[Detroiter]

Yes, but the alert timestamps in previous versions were not on UTC, they were on local server time.

So now i have to manually update all of my SQL queries to subtract 4 hours from the timestamp?  And this is only for the next 6 month until we Fall Back and then i have to do it again to subtract 5 hours?  This was exactly why I all my server to Eastern time regardless of location.

[adatole]

Out of curiosity, what is your timezone and what is the timezone of the polling engine?

[Detroiter]

All have been standardized to Eastern.  All pollers and database servers are set the same.