DateTime off by half hour

0
The datetime variables are off by a half hour. When I import times from an excel sheet via Excel Importer Module, the times that get saved are off by a half hour. I’ve been checking the timezones for my application and they both should be in the correct timezone.  I set the default time zone to Hawaii and I have my datetime variable set to localize.  I’m confused why I’m getting the wrong time value. Any help is appreciated!  
asked
1 answers
2

The excel import/export modules use the server timezone when working with dates.
https://stackoverflow.com/questions/14895739/how-timezone-getdefault-works

That is why you see this discrepancy. To fix this you would need to go over the imported data and manually add offsets as applicable.

-Andrej

answered