> We've had problems (here in the UK) where dateformat would
> allow through
> things that were valid US style (mm/dd/yy) dates, but not
> valid UK style
> (dd/mm/yy) despite settting locale etc. It would basicaly mix
> up day and
> month, if the date made sense in both formats, and was
> entered as a UK style.
> That was CF4.5 though.
Yes, we had similar problems.
to_date('#Dateformat(Now(),'mm/dd/yyyy')#
#TimeFormat(Now(),'HH:mm:ss')#', 'MM/DD/YYYY HH24:MI:SS')
to_char(fieldname, 'YYYY/MM/DD HH24:MI:SS') AS datefield
was our prefered solution. But now i will try the other solutions with
all drivers (Merant JDBC, Oracle JDBC and ODBC)
--
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>
******************************************
----------------------------------------------------------
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]
