Re: format time to local

2009-07-30 Thread Richard White
thanks for the help and link > Richard White wrote: > > yes good point, also there will be users in usa eventually starting > to use it, have you come across this before or seen how others have > dealt with this? > > http://www.sustainablegis.com/blog/cfg11n/index. cfm?mode=cat&catid=162AEDB4-

Re: format time to local

2009-07-26 Thread Aaron Rouse
I store the date based upon the timezone the database server sits in. Then for each location I store the timezone information and do date/time differencing when displaying things for the user to see. What I use is a combination of things within Oracle and some ColdFusion. This in turn takes int

Re: format time to local

2009-07-26 Thread Paul Hastings
Richard White wrote: > yes good point, also there will be users in usa eventually starting to use > it, have you come across this before or seen how others have dealt with this? http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=cat&catid=162AEDB4-20ED-7DEE-2A6CF1B79AC2E03A ~~

Re: format time to local

2009-07-26 Thread Richard White
yes good point, also there will be users in usa eventually starting to use it, have you come across this before or seen how others have dealt with this? thanks >Richard White wrote: >> we have a website used in uk. and the server is in usa. > >and does DST kick in the same time in your timezone

Re: format time to local

2009-07-26 Thread Paul Hastings
Richard White wrote: > we have a website used in uk. and the server is in usa. and does DST kick in the same time in your timezone (tz) as it does in the server's tz? and will this be the case for the life of the app? ~| Want t

Re: format time to local

2009-07-26 Thread Richard White
dateadd worked perfect thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:32

RE: format time to local

2009-07-26 Thread Marius Milosav
Not sure how you are trying to do it, but this should work: #dateAdd("h", 5, "Jul 26 2009 23:48")# Marius -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: July 26, 2009 11:18 AM To: cf-talk Subject: format time to local hi we have a website used in uk. and th

Re: format time to local

2009-07-26 Thread Dave Sueltenfuss
There is a DateAdd function in ColdFusion, which you can use to add hours. Inthe example you provided, it would automatically roll the date over to 4 am the next day On Sun, Jul 26, 2009 at 11:18 AM, Richard White wrote: > > hi > > we have a website used in uk. and the server is in usa. > > whe