Maybe I did not word it right. I know how to do a CFQUERY. When pulling date fields from Oracle, it is something like: to_date(date_field) as ThisDateField
or is it CAST(date_field) That is what I mean not the simple SELECT this FROM that Nor do I mean that a SELECT query is the same as an INSERT query cause that is not the case. Is there anything special in Oracle (not SQL nor MySQL) to insert date variables into date fields? Jochem van Dieten wrote: >ColdFusion Developer wrote: > > >>What is the proper way to select DATE Fields from an Oracle Database >>using CFQUERY? >> >> > >SELECT field FROM table > > > > >>Would it be the same syntax to the insert? >> >> > >Of course not. >INSERT INTO table (field) VALUES (<cfqueryparam ...>) > >Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:146396 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
