Thanks Tom,
> Depends what string format'ed date you supply to them.
Sorry, but i don't understand this answer: thisdate is always of type
date?
It doesn't matter how the user supplies the date information
02.03.2004 (european format)
03/02/2004 (us format)
3,2,2004 - separate entries
...
I am always converting the user entries into a date type field.
(with CreateDateTime(), ParseDateTime(), ...)
So you are still using
to_date('#Dateformat(thisdate,'mm/dd/yyyy')#
#TimeFormat(thisdate,'HH:mm:ss')#', 'MM/DD/YYYY HH24:MI:SS')
instead of
<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
value="#CreateODBCDateTime(thisdate)#">
or
#CreateODBCDateTime(thisdate)#?
I wonder why, it seems to work in all cases?
Are you selecting date fields without calling to_char()?
Harry
--
Harry Klein | Konzeption und Entwicklung
CONTENS Software GmbH
Oettingenstr. 25 | 80538 M�nchen
Fon: +49 (0)89 5199 69-0 | Fax: +49 (0)89 5199 69-78
mailto:[EMAIL PROTECTED] | http://www.contens.de
******************************************
Besuchen Sie CONTENS auf der
iEX Internet Expo 2004 in Z�rich
04. - 06. Februar 2004
Halle 5, Stand 5.163
Mehr Infos finden Sie hier:
www.contens.de/iex <http://www.contens.de/iex>
******************************************
> -----Original Message-----
> From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 14, 2004 3:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [CFCDev] Oracle to_char() and to_date()
>
>
> On Wednesday 14 Jan 2004 13:59 pm, Harry Klein wrote:
> > I use a DAO CFC including Oracle queries.
> > Now i recognized, that the to_char() and to_date() functions are no
> > longer necessary in order to select and update date fields?
> > Is this a new behaviour in Oracle 9, CFMX 6.1 or in the new JDBC
> > Drivers?
>
> Depends what string format'ed date you supply to them.
> We still enforce a particular date/time format for entry by
> users, and use
> to_date with an appropiete format string.
>
> --
> Tom Chiverton
> Advanced ColdFusion Programmer
>
> Tel: +44(0)1749 834997
> email: [EMAIL PROTECTED]
> BlueFinger Limited
> Underwood Business Park
> Wookey Hole Road, WELLS. BA5 1AF
> Tel: +44 (0)1749 834900
> Fax: +44 (0)1749 834901
> web: www.bluefinger.com
> Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
> Quay, BRISTOL. BS1 6EG.
> *** This E-mail contains confidential information for the addressee
> only. If you are not the intended recipient, please notify us
> immediately. You should not use, disclose, distribute or copy this
> communication if received in error. No binding contract will
> result from
> this e-mail until such time as a written document is signed
> on behalf of
> the company. BlueFinger Limited cannot accept responsibility for the
> completeness or accuracy of this message as it has been
> transmitted over
> public networks.***
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email
> to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
> in the message of the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported
> by Mindtool, Corporation (www.mindtool.com).
>
> An archive of the CFCDev list is available at
> www.mail-archive.com/[EMAIL PROTECTED]
>
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
