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]
> > > -------------------------------------------------
> > >
> > >
> >
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
