The following snippet is working correctly for me (using Oracle 8i and CF5):
<CFQUERY NAME="GetMsgs" DATASOURCE="#DSN#" DBTYPE="#DSNType#">
SELECT TO_CHAR(time_stamp,'MM/DD/YYYY HH24:MI') TimeStamp,
display_text
FROM itime_messages
ORDER BY time_stamp DESC
</CFQUERY>
<CFOUTPUT QUERY="GetMsgs">
<P><B>Posted #DateFormat(TimeStamp)# at #TimeFormat(TimeStamp)#
EST</B>
<BR>#ParagraphFormat(HTMLEditFormat(display_text))#
</CFOUTPUT>
Date and time are properly formatted with no extra parsing being done.
Apparently CF5's date and time formatting can handle the TO_CHAR version of
the date.
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
-----Original Message-----
From: Bruce Holm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 1:33 PM
To: CF-Talk
Subject: Re: Retrieving Time in a Query
If I try #parseDateTime(date)# where date is the column name containing an
Oracle date/time object, I get:
{ts '2002-07-08 00:00:00'}
As you can see, the time is not there, it contains 7:00 am in my example.
Bruce
----- Original Message -----
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 10:15 AM
Subject: Re: Retrieving Time in a Query
> Not sure, I do not use Oracle...and did not have to use a SQL function
first
> to get the desired result. all I did was a regular select and use
> parseDateTime()
>
>
>
>
> Douglas Brown
> Email: [EMAIL PROTECTED]
> ----- Original Message -----
> From: "Bruce Holm" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 09, 2002 10:01 AM
> Subject: Re: Retrieving Time in a Query
>
>
> > This does work, but is there a more efficient (direct) way of doing this
> > without using a SQL function and a CF function?
> > If not I'll go with this.
> >
> > In my query I specify one of the columns as:
> >
> > TO_CHAR(event_start,'MM/DD/RR HH24:MI') testDateTime
> >
> > Then in CF I use:
> >
> > #parseDateTime(qGetResItem.testDateTime)#
> >
> > and it returns a date/time object: {ts '2002-07-08 07:00:00'}
> >
> > Seems a long way around. Why can't CF query get the date/time object
WITH
> > the time in it???
> >
> > Bruce
> >
> >
> > ----- Original Message -----
> > From: "Douglas Brown" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 09, 2002 9:47 AM
> > Subject: Re: Retrieving Time in a Query
> >
> >
> > > Can't you use parseDateTime(date)
> > >
> > >
> > >
> > >
> > > Douglas Brown
> > > Email: [EMAIL PROTECTED]
> > > ----- Original Message -----
> > > From: "Douglas Brown" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, July 09, 2002 9:39 AM
> > > Subject: Re: Retrieving Time in a Query
> > >
> > >
> > > > Cant you do dateFormat(date,"dd-mm-yyyy") timeFormat(date,
"hh:mm:ss")
> > What
> > > > happens when you do this?
> > > >
> > > >
> > > >
> > > >
> > > > Douglas Brown
> > > > Email: [EMAIL PROTECTED]
> > > > ----- Original Message -----
> > > > From: "Bruce Holm" <[EMAIL PROTECTED]>
> > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, July 09, 2002 9:32 AM
> > > > Subject: Retrieving Time in a Query
> > > >
> > > >
> > > > > How do you get the "time" portion of a DateTime object stored in
an
> > Oracle
> > > > > database?
> > > > >
> > > > > I have a column in a table that is of type "date". I can query
this
> > field
> > > > > and view the date portion but the time portion is always 0:00
(12:00
> > AM).
> > > > > The time IS reallly stored in the column, but the query CF does
only
> > gets
> > > > > the date portion. It appears to be getting the default Oracle db
> > value of
> > > > > the date portion combined with 0:00 for time.
> > > > >
> > > > >
> > > > > -------------------------------------------------
> > > > > Bruce Holm - Web Programmer
> > > > > Lattice Semiconductor Corp.
> > > > > [EMAIL PROTECTED]
> > > > > -------------------------------------------------
> > > > >
> > > > >
> > > >
> > >
> >
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
