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?
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.
Reply With Quote
Originally Posted by tamade
Bookmarks