Re: simple question about default date mask?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: 2000/01/07
Message-ID: <947278786.21665.0.pluto.d4ee154e@news.demon.nl>#1/1

alter session set nls_date_format = 'dd-Mon-yyyy'

Your welcome,

--
Sybrand Bakker, Oracle DBA
<yliu_at_creighton.edu> wrote in message
news:Pine.HPP.3.95.1000107141306.24917A-100000_at_penguin.creighton.edu...


> Hi All,

>

> Could somebody please tell me how to set the default mask of a session to

> include the four digit year? Currently, my sql*plus date mask is

> 'dd-Mon-yy', and I wanted it to be 'dd-Mon-yyyy' just for my current

> session.

>

> Thank you very much for your time.

>

> Yongge

>

>

Received on Fri Jan 07 2000 - 00:00:00 CST