#1126 accepted

DateTime is converted from local time to UTC automatically - when using JDBC for SqlServer

Reported by scleveland | November 16th, 2009 @ 06:57 PM

When storing a DateTime that is formatted for local time is is being converted to UTC time automatically when what I want is to store the local time with the offset. Also, after the UTC conversion the offset is still the same and should be O in the DateTime value. For example, 2009-10-23T14:30:00-07:00 will store just like this in the local sqlite3 database but when stored to the sqlserver using the jdbc-do_sqlserver adapter the result is 2009-10-23T21:30:00-07:00 - these values are not equal and therefore querying by DateTime will yield no results.

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »