Have you tried the sql using sqlplus? If that returns just the date portion then I would say you have to cast it or look at the default date/time oracle settings.
On 2 July 2010 12:46, Steve Onnis <[email protected]> wrote: > In addition if i run the same query in CFBuilder the date value comes back > correctly. If i run it in the browser through ColdFusion then the time is > 00:00. This leads me to assume that ColdFusion is doing some data typing > with the recordset when it comes back. Is this a correct assumption? Or > does ColdFusion just use what it was given? I am just thinking that > ColdFusion sees the DATE type column and just wants to give back the date > rather than what was actually returned from the database. > > Steve > > > -----Original Message----- > From: Steve Onnis [mailto:[email protected]] > Sent: Friday, 2 July 2010 11:36 AM > To: [email protected] > Subject: RE: [cfaussie] Oracle thin driver and DATE columns > > Its kinda hard to do that. The same code needs to work in MSSQL and Oracle. > If i do that i need to find everywhere where it is being used > > -----Original Message----- > From: Zac Spitzer [mailto:[email protected]] > Sent: Friday, 2 July 2010 11:34 AM > To: [email protected] > Subject: Re: [cfaussie] Oracle thin driver and DATE columns > > try cast as timestamp ? > > On 2 July 2010 11:59, Steve Onnis <[email protected]> wrote: > > I am having this issue that is driving me crazy. I have a > > > > > > > > - CF8.0.1 STD server connecting to an Oracle DB > > > > - Oracle 10g Express database > > > > - Using ojdbc14.jar (1,555,682 bytes) - classes for use with JDK 1.4 and > 1.5 > > jdbc drivers > > > > - Column type is DATE > > > > > > > > If i look in the database the data in the column shows the date has a > time > > portion. When i do a query on it i am not being returned the time portion > > > > > > > > Here is an example of a query.... > > > > > > > > SELECT STATUSHLDATE, > > > > to_char(STATUSHLDATE, 'YYYY-MM-DD HH24:MI:SS') AS > STATUSHLDATE2 > > > > FROM WHPROJECTS > > > > > > > > This is what i am getting back.... > > > > > > > > STATUSHLDATE = {ts '2010-06-30 00:00:00'} > > > > STATUSHLDATE2 = 2010-06-30 16:51:33 > > > > > > > > I know the whole date/time is there. Funny thing is that if i use the > RDS > > Query Viewer in CFBuilder i actually get the whole date/time value, just > not > > when it is being returned to CF. Is this an issue with CF seeing is as a > > DATE type field and stripping the time out? > > > > > > > > Steve > > > > -- > > You received this message because you are subscribed to the Google Groups > > "cfaussie" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<cfaussie%[email protected]> > . > > For more options, visit this group at > > http://groups.google.com/group/cfaussie?hl=en. > > > > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > http://www.ennoble.com.au > http://zacster.blogspot.com > +61 405 847 168 > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<cfaussie%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<cfaussie%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<cfaussie%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
