DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: ORA-01843: not a valid month

  1. #11
    Join Date
    Dec 2005
    Location
    Hangzhou, China
    Posts
    7
    Mr Tamil,
    I didn't read too much of these posts, I saw your words after I posted mine, and I agree with you. But still wonder why guys here have talked soooo much about this simple problem? Or is there anything else wrong?

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    its bad coding - simple as that

  3. #13
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by tamade
    Mr Tamil,
    I didn't read too much of these posts, I saw your words after I posted mine, and I agree with you. But still wonder why guys here have talked soooo much about this simple problem? Or is there anything else wrong?
    You have to treat date with date datatype only. You should not compromise on that.
    I have seen and still am seeing that developers did not treat date as date datatype in Oracle. This posed severe performance problem. If you write date as varchar2 column in a procedure in Oracle 8i, the procedure hangs under certain circumstances.

    Tamil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width