If you want to format a date as it comes out of the database, you can
use to_char(yourdatefield, 'yourdatemask'). If not, it'll just come
out in the default format, and you can still format it in cf with
dateformat(). In other words, it's optional, and just selecting the
date will work fine.
As J
ColdFusion Developer wrote:
>
> When pulling date fields from Oracle, it is something like:
> to_date(date_field) as ThisDateField
>
> or is it CAST(date_field)
It is just cfqueryparam, that will take care of proper typecasting.
> Is there anything special in Oracle (not SQL nor MySQL) to inse
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 INSE
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 ()
Jochem
~
What is the proper way to select DATE Fields from an Oracle Database
using CFQUERY?
Would it be the same syntax to the insert?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www