I am trying to run an update statement that will add one day to a specific date field. Here is my update statement.
update employee
set empenddate = empbegindate +1
where empbegindate = empenddate
I don't know how to add an extra day to the empbegindate field. What I am trying to do is add an extra day to the empenddate because I have records that have the same dates in each field.
zero
update employee
set empenddate = empbegindate +1
where empbegindate = empenddate
I don't know how to add an extra day to the empbegindate field. What I am trying to do is add an extra day to the empenddate because I have records that have the same dates in each field.
zero