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!

adding a day to a date column

446155Jun 16 2006 — edited Jun 19 2006
Hi,

i have this date column containing values with the format as
"MMDDYYYY HH24MISS"
an example would be

"06/07/2005 00:00:00 AM"

Now when i add a day to these columns values as

update table
set column = column+1

i get the final value as ""06/08/2005" and the HHMMSS value is removed for those columns which initially had "00:00:00 AM"

what i want to do is, when i add a day to the present value i need to see the result as
"06/08/2005 00:00:00 AM" and not as "06/08/2005"

How do i do this. Can someone help please.

Thanks,
Philip.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2006
Added on Jun 16 2006
17 comments
873 views