Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle dates & Powerbuildr

Re: Oracle dates & Powerbuildr

From: Dag Arne Matre <dag-arne.matre_at_spectec.net>
Date: Sat, 2 Jun 2001 09:57:53 +0200
Message-ID: <xZ0S6.4352$vu4.455618@news3.oke.nextra.no>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US