Re: Change Date time format.

From: Michael S. Abbey <masint_at_istar.ca>
Date: 1998/03/10
Message-ID: <34f37246.80295278@news.istar.ca>#1/1

On Tue, 24 Feb 1998 13:32:14 +0800, "khuang" <khuang_at_accton.com.tw> wrote:

>Hi guys:
> I want to change default datetime format on Oracle 7.3.3 NT server from
>'DD-MMM-YY' to 'YYYY/MM/DD'. Anyone know how to do it.
 -
>George Huang
>At Accton Technology

Try setting NLS_DATE_FORMAT in init.ora to YYYY/MM/DD and see how that works.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Tue Mar 10 1998 - 00:00:00 CST