Re: default date format change in Oracle 7.1.4 on HP-UX 9.04

From: William WW LEE <william_at_alumni.cuhk.edu.hk>
Date: 1996/04/20
Message-ID: <4lb8sg$5h2_at_hpg30a.csc.cuhk.hk>#1/1

srijay_at_ix.netcom.com(Srikanth Narasimhan) wrote:

>Hi all,
>We have set NLS format for the date YYYYMMDD HH24:MI:SS in the initora
>file. But during runtime, sometimes sysdate retrieves date in the
>format DD-MON-YY from the PRO*C program. Can someone tell us why this
>is happening and the possible solutions?

Try setting the NLS_DATE_FORMAT environment variable also. Received on Sat Apr 20 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Mike Openshaw: "Re: Designer/2000 Learning curve approach?"
Previous message: Larry: "Re: Moving tables from Access to Oracle"
In reply to: Srikanth Narasimhan: "default date format change in Oracle 7.1.4 on HP-UX 9.04"
In reply to Srikanth Narasimhan: "default date format change in Oracle 7.1.4 on HP-UX 9.04"
Next in thread: Mike Openshaw: "Re: Designer/2000 Learning curve approach?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message