Re: Date format? [message #372404] |
Fri, 09 February 2001 08:46 |
Bala
Messages: 205 Registered: November 1999
|
Senior Member |
|
|
Hi,
It depends what date format your database has
nls_date_format, or which date format is assigned to your session.
BINTEST> alter session set nls_date_format = 'DD/MM/YYYY';
Session altered.
BINTEST> select sysdate from dual;
SYSDATE
----------
09/02/2001
The bottom line is the date is stored in oracle internally in a binary format, can be displayed in any format you want.
Bala
|
|
|