• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle date format issue

 
Anand Bhatt
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Anand,

Try DD-Mon-RR format.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks both ,Nice advice, i will try and share the results with you as well.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic