And what about the states that don't observer DST?????
I think you would be best to look at the Calendar class (and getTimeZone). Since I assume your clients will be in different timezones, you would have to rely on the time coming from the client and passing that to SQL:
http://java.sun.com/j2se/1.5.0/docs/.../Calendar.html
Brett
Perfect Computing, Inc...
arbert
Last Activity: Mar 21 '08, 01:41 PM
Joined: May 6 '06
Location:
-
Ouch. I know it doesn't directly answer your question, but why are you performing an update like that??? It's slow and has a lot of overhead--you should think about passing a CONN.EXECUTE statement or best yet--use a stored proc for the update.
Brett
Perfect Computing, Inc...Leave a comment:
-
Everything you could possibly want to know on connectivity issues:
http://blogs.msdn.com/sql_protocols/...22/506607.aspx
Brett
Perfect Computing, Inc...Last edited by arbert; May 16 '06, 05:38 AM.Leave a comment:
-
What database and what front-end language.Leave a comment:
-
Need a little bit more to go on--such as your open statements for the database connection and the recordset.Leave a comment:
-
Quest is definately a top-notch way to go. With the technology they gleaned from Imceda, they definately produce some great products. Their LiteSpeed is hard to beat for backups.
Symantec/Veritas, or whatever their company name is today, as a product called I3 that is really nice as well. We bought the product when it was called Precise (so was the company). It got bought out and the rest is history. The thing about I3--it does...Leave a comment:
No activity results to display
Leave a comment: