Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle 10, o90 client DBMS, datetime conversion to TO_TIMESTAMP

22 views
Skip to first unread message

Matthieu

unread,
Mar 22, 2006, 10:04:20 AM3/22/06
to
Hi every one.

PB10.2, DBMS o90, Oarcle 9 client, Oracle 10 database.

We've got several datawindow that receive datetime type
retrieval arguments used in the SQL statement (... and
table.field < :adt_date).

With o84 DBMS (Oracle 8), this parameter is converted by the
driver as "TO_DATE ('1-02-2006 00:00:00', 'DD-MM-YYYY
24:MI:SS')".
With o90, the parameter value is translated in "TO_TIMESTAMP
('1-02-2006 00:00:00', 'DD-MM-YYYY 24:MI:SS')".
whereas we don't use any millisecond value as outlined here:
http://manuals.sybase.com/onlinebooks/group-pb/pbr0900e/pbentrb/@Generic__BookTextView/723;
pt=720/*#X

Is there a way to force the PB DBMS driver to translate all
datetime into TO_DATE(...) instead of TO_TIMESTAMP without
setting the DBParm Timestamp to No ?

Thanks in advance for your assistance

0 new messages