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
: 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
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
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
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?
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:
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
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
-
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
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
(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
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
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
: 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
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
)#/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
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
17 matches
Mail list logo