Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update date Column

user8983130Dec 17 2012 — edited Dec 17 2012
Hi,

I have always problem with date function. I need to update some columns value who's type is date. When i query from CMD, it returns value like 14-NOV-06 and when i query from toad it returns value 11/14/2006. How can i update the column value without type mismatch.

Please help me...

Thanks and regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2013
Added on Dec 17 2012
12 comments
2,482 views