From: "Philip Arnold"
> > From: Pascal Peters
> >
> > On Oracle:
> > WHERE TRUNC(event_date) = TO_DATE(<cfqueryparam
> > cfsqltype="CF_SQL_VARCHAR"
> > value="#Dateformat(show_event_date,'yyyy-mm-dd')#">,'YYYY-MM-DD')
>
> Why wouldn't you use CF_SQL_DATE as the cfsqltype?
Oracle's dateformat doesn't seem to correspond with the cf_sql_date format
very well, particularly if your Oracle environment has set up a non-standard
date format (not uncommon). It also might be that the cf_sql_date format,
when used with Oracle, automatically passes a timestamp as well. There's no
separate data type for date with time/date without time in Oracle. I'm not
sure on that, but I think it makes sense. I use varchar, as well, and just
send the matching date format string.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
