-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdateAllTimes.sql
13 lines (10 loc) · 1.15 KB
/
updateAllTimes.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
-- Adjust all times in OpenMRS patient data by n hours
update allergy set date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
update conditions set date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
update encounter set encounter_datetime = DATE_ADD(encounter_datetime, INTERVAL @hoursToAdd HOUR), date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
update encounter_provider set date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
update encounter_diagnosis set date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
update obs set obs_datetime = DATE_ADD(obs_datetime, INTERVAL @hoursToAdd HOUR), date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
update orders set date_activated = DATE_ADD(date_activated, INTERVAL @hoursToAdd HOUR), date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR), date_voided = DATE_ADD(date_voided, INTERVAL @hoursToAdd HOUR);
update visit set date_started = DATE_ADD(date_started, INTERVAL @hoursToAdd HOUR), date_created = DATE_ADD(date_created, INTERVAL @hoursToAdd HOUR);
select CONCAT('All times updated by ', @hoursToAdd, ' hours');