- see footer for list info -<
HI Stephen,
That's not the problem... the problem is that JDBC is applying daylight saving to the datefield, and I don't want it to:) We found a way round it though.. for now ;) As the product is end of life, I'm hoping I wont have to do this again next year. Either way we'll have it sorted by then. Thanks though. Tom On 27/03/07, Stephen Moretti <[EMAIL PROTECTED]> wrote:
>- see footer for list info -< You probably want this Technote from adobe, but I'm getting a "broken" notice from the site at the minute... http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470 On 27/03/07, Tom Shearer (lists) <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > hi Paul... > > Thankfully the issue only shows up on our old system ;) As you may know I > wrote the new system to take this into account (hell I used the hastings > locale stuff you pointed me to at the time)... but you know dodgy Dave ;) > To be honest though, if the team hadn't added some hardcore reporting to > the > said application this probably would never have been spotted. Either way > it's still an end of life system that needs to be taken out with a > hacksaw. > > You should see the next incarnation of the cd-rom - you'd be surprised by > it! > > Tom > > On 27/03/07, Paul Vernon <[EMAIL PROTECTED]> wrote: > > > > >- 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 > > -< > > > _______________________________________________ > > 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 > -< > _______________________________________________ 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 -<
_______________________________________________ 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 -<
