Doug. Try extracting the time portion out separately with this format: SELECT to_char(a.inactive_d,'HH24Mi') inactive_t
Hope that helps ya. -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 1:16 PM To: CF-Talk 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] > > > > ------------------------------------------------- > > > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
