DAY_DIFFERENCE and Daylight Saving

If you think that something doesn't work in Aware IM post your message here
Post Reply
UnionSystems
Posts: 197
Joined: Fri Jun 17, 2016 7:10 am
Location: Brisbane Australia
Contact:
Contact UnionSystems

DAY_DIFFERENCE and Daylight Saving

Post by UnionSystems »

We have observed an issue when using DAY_DIFFERENCE in a Daylight Saving timezone.

If the period the 2 dates used as parameters for DAY_DIFFERENCE includes the day the Daylight Saving starts then the integer generated by DAY_DIFFERENCE is 1 less than expected.

So for example in Brisbane Australia (with no Daylight Saving) it correctly shows a difference of 2 days.

Image

But in Sydney Australia (which has Daylight Saving and in 2018 Daylight Saving starts on 7th October) it incorrectly shows a difference of only 1 day. Assume this is because the Sunday effectively only has 23 hours?

Image
Attachments
screen 2.png
screen 2.png (18.6 KiB) Viewed 4146 times
screen 1.png
screen 1.png (18.7 KiB) Viewed 4146 times
AWS Linux, Windows Server, AIM 8.4 & 8.6
Top
Post Reply

Return to “Problem reports”