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
-
Dan Kubb (dkubb) November 16th, 2009 @ 07:03 PM
- State changed from “new” to “unconfirmed”
- Assigned user set to “Alex Coles”
Assigning this to Alex because the tags show jdbc/sqlserver, although I am not sure if this is related to the MRI problems I've seen with DateTime objects.
-
Alex Coles November 17th, 2009 @ 08:54 AM
- State changed from “unconfirmed” to “accepted”
-
Alex Coles November 28th, 2009 @ 08:04 AM
- Milestone set to “0.10.2”
-
Dan Kubb (dkubb) February 1st, 2010 @ 04:33 PM
- Milestone changed from “0.10.2” to “1.0.0”
-
Dan Kubb (dkubb) May 26th, 2010 @ 01:14 AM
- Milestone cleared.
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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Alex Coles
Dan Kubb (dkubb)
Piotr Solnica (solnic)