Re: SQL solution for my JDBC timezone issue

[George Woodring <george.woodring@xxxxxxxxxx>]

So:

    JDBC Web servers(US/East)  <---> 90 database (5 different timezones)

Therefore everything to the end user is passed through the Web servers?

Is there a reason why the databases have different timezones?

Seems to me less complicated to have all the databases share the UTC timezone. Then you only have one offset, US/East <--> UTC.

We originally did it for simplicity sake, the database is set for our customer's timezone.  So when we grabbed a date from the db, it would in the correct timezone for the viewer, without the web code having to know the timezone.

George Woodring

iGLASS Networks
www.iglass.net