adding a day to a date column
446155Jun 16 2006 — edited Jun 19 2006Hi,
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.