Re: Timezones and CF

2002-09-19 Thread Jochem van Dieten
Dan Haley wrote: Near as I can tell the Oracle equivalent of this is new_time(). The Oracle equivalent of current_timestamp is current_timestamp. http://www.google.com/search?q=oracle+current_timestamp http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/functions31.htm

RE: Timezones and CF

2002-09-19 Thread Dan Haley
: Timezones and CF Dan Haley wrote: Near as I can tell the Oracle equivalent of this is new_time(). The Oracle equivalent of current_timestamp is current_timestamp. http://www.google.com/search?q=oracle+current_timestamp http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/fu

Re: Timezones and CF

2002-09-18 Thread Jochem van Dieten
Use a database. SELECT Now() AT TIME ZONE '#your_time_zone#' AS MyTime It is part of SQL-92 and it handles DST and dates correctly. IRL YMMV Jochem __ Your ad could be here. Monies from ads go to support these lists and

RE: Timezones and CF

2002-09-18 Thread Greg Luce
What DB are you using? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:08 AM To: CF-Talk Subject: Re: Timezones and CF Use a database. SELECT Now() AT TIME ZONE '#your_time_zone#' AS MyTime It is part of SQL-92 and it handles

Re: Timezones and CF

2002-09-18 Thread Mark
I use... don't hate me Acesss! For the scale of things it's fine.. I used the code... cfset austime= #now()# + #createTimeSpan(0,8,0,0)# from Michael Kear... and it's worked fine... with the time dunno about the day yet... but he says it works. What DB are you using?

Re: Timezones and CF

2002-09-18 Thread Jochem van Dieten
Greg Luce wrote: What DB are you using? PostgreSQL. Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: Timezones and CF

2002-09-18 Thread Greg Luce
I'm just familiar with Oracle, SQLServer, and Access. Oracle has sysdate, while I believe SQL and Access use getdate(). -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:55 PM To: CF-Talk Subject: Re: Timezones and CF Greg Luce

Re: Timezones and CF

2002-09-18 Thread Jochem van Dieten
Greg Luce wrote: I'm just familiar with Oracle, SQLServer, and Access. Oracle has sysdate, while I believe SQL and Access use getdate(). You are right. If we are going to do it according to the standards, better do everything according to the standards :) SELECT current_timestamp AT TIME

RE: Timezones and CF

2002-09-18 Thread Dan Haley
- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:29 PM To: CF-Talk Subject: Re: Timezones and CF Greg Luce wrote: I'm just familiar with Oracle, SQLServer, and Access. Oracle has sysdate, while I believe SQL and Access use getdate(). You are right

Timezones and CF

2002-09-17 Thread Mark
Hullo, I wondered if someone could help me... also I'm new here... please be gentle. I have a problem with adding dates and times - I just can't get my head around it - and at the moment it doesn't work cfoutput#timeformat(dateadd(h,5,now()),HH:mm)#/cfoutput whoo give me the correct time

RE: Timezones and CF

2002-09-17 Thread Matthew Walker
(h,5,now()) -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 September 2002 11:04 a.m. To: CF-Talk Subject: Timezones and CF Hullo, I wondered if someone could help me... also I'm new here... please be gentle. I have a problem with adding dates

Re: Timezones and CF

2002-09-17 Thread Mark
Just an to clarify . the + 5 hours, works apart from it doesn't accommodate the date... so if its Wednesday 7.05pm in the US - then it should be 12.05 Thursday here... whoo! dateadd works... although... the +5 hours get the right time... the date is still the previous day i.e.. 12.05 Wednesday

RE: Timezones and CF

2002-09-17 Thread Tony Weeg
how about trying the same timeformat function stuff to a DateFormat function to return the adjusted day? tony -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 7:34 PM To: CF-Talk Subject: Re: Timezones and CF Just an to clarify the + 5

RE: Timezones and CF

2002-09-17 Thread Matthew Walker
: Wednesday, 18 September 2002 11:34 a.m. To: CF-Talk Subject: Re: Timezones and CF Just an to clarify . the + 5 hours, works apart from it doesn't accommodate the date... so if its Wednesday 7.05pm in the US - then it should be 12.05 Thursday here... whoo! dateadd works... although

Re: Timezones and CF

2002-09-17 Thread Mark
The date only needs be updated between 12.00 midnight and 5.00am gmt - and to add insult to injury - what about Daylight savinng that happens just about halloween? You seem to be saying cfoutput#dateadd(h,5,now())#/cfoutput doesn't increment the day. Try this test, cfoutput #now()#br

RE: Timezones and CF

2002-09-17 Thread Matthew Walker
)#/cfoutput cfoutput#dateformat(request.gmt,dd/mm/)#/cfoutput -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 September 2002 11:51 a.m. To: CF-Talk Subject: Re: Timezones and CF The date only needs be updated between 12.00 midnight and 5.00am gmt

RE: Timezones and CF

2002-09-17 Thread Michael Kear
AM To: CF-Talk Subject: Re: Timezones and CF The date only needs be updated between 12.00 midnight and 5.00am gmt - and to add insult to injury - what about Daylight savinng that happens just about halloween? You seem to be saying cfoutput#dateadd(h,5,now())#/cfoutput doesn't increment the day