Re: BUG for date
Pascal Paradis-Théberge <[email protected]>
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
I thought java.sql.Date had no time component (the time fields are all set to 0) so from this it follows that it doesn't matter which timezone the client machine is in, a date should be the same. Or am I missing something? Pascal Patrick wrote: Well no. The date is NOT the date across timezones. In the US for instance the date changes one hour earlier in the east than it does in the US Central timezone. -----Original Message----- From: [email protected] [ mailto:[email protected] ] On Behalf Of Gorazd Praprotnik Sent: Thursday, February 10, 2005 2:34 PM To: [email protected] Subject: Re: BUG for date Hi, Rick. Yes, you are right. If I change timezone, values are right. Thank you for replay. But for me is still bug, because date is date, and it must be same in every time zone. I'd tested with other drivers and things worked fine. I think you shoud repair this bug, even it is more academic issue. Thank you again. Have a nice day. Gorazd ----- Original Message ----- From: "Rick Knowles" <[email protected]> To: <[email protected]> Sent: Thursday, February 10, 2005 3:19 AM Subject: Re: BUG for date Are you sure that's not a timezone bug in your application (ie you write the date from a machine that has a different timezone to the one you're reading it from ?) Rick Gorazd Praprotnik wrote: Hi Toby! I'm testing your DB, but I found very nasty bug. If I write some date (java.sql.Date), let say 31.12.2004 into your DB in win98, when I call function rs.getDate in XP windows, I get date 30.12.2004. If I call that function in win98, I get normal date (31.12.2004). With others drivers, it works normal. Can you explain that and if is there some bypass to this bug. Gorazd -- Servlet v2.4 container in a single 140KB jar file ? Try Winstone ( http://winstone.sf.net/ ) --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected] --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected] --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected] --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]