I
don't have a 6.0 to test this on, but I tried it on 5.5 and the
createODBCDateTime() did work.
I was
wondering what magic makes it work at all. I notice that the SQL
statements that are actually getting run are this:
//
When you use #CreateODBCDate(now() )#
SELECT
* FROM DUAL WHERE SYSDATE - 1 <TO_DATE ('2003-09-04',
'YYYY-MM-DD')
//
When you use #CreateODBCDateTime(now() )#
SELECT
* FROM DUAL WHERE SYSDATE - 1 <TO_TIMESTAMP ('2003-09-04 10:04:42',
'YYYY-MM-DD HH24:MI:SS.FF')
The
query errors because TO_TIMESTAMP is not a valid Oracle function in Oracle
Version 8 (It is in Oracle version 9, though)!!
// In
5.0, it did this for #CreateODBCDateTime(now() )#:
SELECT * FROM DUAL WHERE SYSDATE - 1 <
TO_DATE('2003-09-04 10:03:01','YYYY-MM-DD HH24:MI:SS')Which
worked just fine.
-----Original Message-----
From: Davis, Eric [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:52 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [CFCDev] OT: CFMX 6.1, Oracle 8.05, CreateODBCDateTime()The code is never missing pound signs.The exact same code - no changes at all - worked just fine under 6.0.Under 6.1, the difference between working and not working is whether we evaluate a #CreateODBCDate(foo)# or a #CreateODBCDateTime(foo)# in the query.
