Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle dates & Powerbuildr
"Geo" <gkont_at_emphasis-systems.gr> wrote in message
news:fc9d4037.0106010125.455fe39_at_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')
>
Option 1 (if Jun is not Jun in Greek):
EXECUTE IMMEDIATE "ALTER SESSION SET NLS_DATE_LANGUAGE = 'AMERICAN'";
Option 2:
Check out the DateTime DBParm parameter in your PB documentation, if
necessary combined with a "ALTER SESSION SET NLS_DATE_FORMAT ..."
You should also get the latest O84 dlls and use these.
HTH,
D A
Received on Sat Jun 02 2001 - 02:57:53 CDT