Oracle date format issue

[Anand Bhatt]

I have one table having one column create_date and data type for same is DATE.
One external program populating this column's values in DD-Mon-YY format. Ideally for e.g if external sytem want to populate this column value with value like '27-04-11'.
it is refelcting as 27-04-1911 in table's columns .
So any one have any idea or faced some issue please suggest.

I am using Oracle10g.

[Fatih Keles]

Hi Anand,

Try DD-Mon-RR format.

[Avi Abrami]

Anand,
If I remember correctly, DATE values are stored in Oracle database as numbers that take up seven bytes of storage.
Date formats are only used for displaying the date.
Hence the format you use is entirely arbitrary.
And since the Y2K bug, I believe most people would agree with me that using four digit years in date formats is preferrable.

Good Luck,
Avi.
P.S. By the way, as far as I know, eg is an abbreviation for the phrase "for example" so I would say that writing "for eg" means "for for example" which doesn't sound correct to me.

[Anand Bhatt]

Thanks both ,Nice advice, i will try and share the results with you as well.