---
I am no expert on that, but what date format would be allowed using
cf_sql_date?
My experience is that, due to the different server configs we have in
Europe (and especially Belgium), using to_date was the only safe
alternative when moving an app around (dev, testing, staging, prod). I
usually have no control or access over the client db's (apart from
sending them the scripts to create the schema).
Pascal
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 15 juni 2004 15:15
> To: CF-Talk
> Subject: RE: CF Dates with MX 6.1 ?
>
> Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166646
> ---
> huh? Looks like Ian is using a DATE type, no need for
> to_date() then at all.
>
> WHERE startdate <= <cfqueryparam cfsqltype="cf_sql_date"
> value="#startdate#" />
>
> Of course, if using CACHEDWITHIN attribute, then you can't
> use the cfqueryparam, then u have to use to_date() WHERE
> startdate <=
> TO_DATE('#DateFormat(startdate,'yyyy-mm-dd')#','yyyy-mm-dd')
>
> You could also look at ALLTER SESSION in Oracel to set your
> default date format and not need to_date at all.
>
> Doug
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
