Oracle dates & Powerbuildr

From: Geo <gkont_at_emphasis-systems.gr>
Date: 1 Jun 2001 02:25:19 -0700
Message-ID: <fc9d4037.0106010125.455fe39@posting.google.com>

Hello there,
I am using Powerbuilder 6.1.5 and Oracle 8.1.5 My project is to migrate from MSSql to Oracle and i don't know if it is better to connect to my database through an ODBC profile or should i use OR8 ORACLE 8.0 Profile.

If i use OR8 Profile how can i change the Oracle default date format?
I have set the nls_lang parameter into GREEK_GREECE.EL8MSWIN1253 and the nls_date = dd/mm/yyyy but when i update a row from my Powerbuilder application
the sql is:
update ...set...
where date_column = TO_DATE('1-Jun-2001 00:00:00', 'DD-MON-YYYY HH24:MI:SS')

THANKS Please help!! Received on Fri Jun 01 2001 - 04:25:19 CDT