The ORACLE docs site may help, the index you're after in this case is: http://www.oracle.com/pls/db92/db92.sql_keywords?letter=T&category=#index-TO
ps assuming you're using 9i that is, the 8i & 10g docs are also there of course. On Tue, 25 Jan 2005 05:54:13 -0500, ColdFusion Developer <[EMAIL PROTECTED]> wrote: > Thanks, like I said, been a long time since I used it. > By chance any website you may have I can reference for more > questions like this? > > Thanks again! > > James Holmes wrote: > > >INSERT / UPDATE with to_date() > >SELECT with to_char() > > > >-----Original Message----- > >From: ColdFusion Developer [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, 25 January 2005 6:48 > >To: CF-Talk > >Subject: Oracle Date Field > > > >Using a CF Query to add a record to Oracle, I havea date field to add When > >adding it, it is straightforward, right? > > > >When retrieving the date information, I need to do a To_Date function? > > > >Is that correct? > > > >Been a long time since I had to use Oracle. > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191673 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54