[Babase] Agonism, Grooming, and Samples tables updated
Leah Gerber
leah.gerber at duke.edu
Sun May 6 19:24:50 EDT 2007
Hello Karl,
I managed to make the update statements work with the following code. I
changed all of the grooming and agonisms that you wanted on the first of
the month. My question is whether you want the datetime field changed as
well for these records. They do not match the date now.
UPDATE interact;
SET date = CTOD('1/' + STR(MONTH(date),2) + '/' + STR(YEAR(date),4));
WHERE DAY(date) != 1;
AND (act = "A" OR act = "AS" OR act = "OS" OR act = "DS");
AND YEAR(date) < 1995;
AND sid=0;
UPDATE interact;
SET date = CTOD('1/' + STR(MONTH(date),2) + '/' + STR(YEAR(date),4));
WHERE DAY(date) != 1;
AND act = "G";
AND YEAR(date) < 2006;
AND sid=0;
I also updated the Samples table by changing the SETUP_JUL13 back to
SETUP_JUL03.
New versions of this data are on papio as well as the dump files. These
changes have been recorded in the babasechangelog which is also on papio
now.
Please let me know if I should change the datetime field. Could we run a
new conversion now?
Thanks,
Leah
More information about the Babase
mailing list