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]. > 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]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
