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.
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.
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.
Joined: May 30, 2007
Thanks both ,Nice advice, i will try and share the results with you as well.