Re: Update datetime in MySQL
So I get far to this point
update visit
set start_of_service=DATE_ADD(start_of_service, INTERVAL 1 HOUR) ,
end_of_service=DATE_ADD(end_of_service, INTERVAL 1 HOUR)
where (TIME(start_of_service)='23:00:00' OR TIME(end_of_service)='23:00:00') AND
(MONTH(CREATE_DATE) = 1 AND YEAR(CREATE_DATE) = 2014) AND
visit_id IN (
select v.VISIT_ID
from PATIENT_INFORMATION p, VISIT v
where v.PATIENT_INFO_ID = p.PATIENT_INFO_ID and
p.DATA_DOMAIN = 'FOLLOWUP'
);
But I am getting Error code 1093.
I wan to update time in visit table which has matching visit id in patient table.
Subject
Written By
Posted
February 20, 2014 05:21PM
Re: Update datetime in MySQL
February 21, 2014 11:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.