>- see footer for list info -< > After some digging I found that JDBC converts the dates to a > string using a timezone offset set on the server... bloody > windows. why it would only do it at that time is completely > beyond me.
Tom, For an application like yours, I would have expected your servers to be set to UTC and *never* change to BST... Doing this, you should then using some CF magic and offset the times for display purposes only.... The thing is though, to correct this you either have to set the servers back to UTC and make the corrections in the DB or wait till we go back to UTC in the autumn and remember to set the servers to never use DST after they are back on UTC. I'd go for the former as remembering to do that six months from now is not going to happen!!! Also, how are you handling the display of datetimes for your global users at the mo? I assume you're showing them server local times? If you use UTC and do the offsets based on the users timezone, you will always be right according to their timezones and life will be peachy! You know where I am if you need any more assistance :) Paul _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
