View source for AccessConversion

== The Process ==

Initially you will want to work in the <code>gombemi_raw</code> database to convert the data with minimal data integrity rules.  Later you can work in <code>gombemi_test</code> to convert with data integrity rules in place and finally in <code>gombemi</code> to do the final conversion.

The general outline is as follows:

* Import all the support (lookup) tables
* Import the <code>BIOGRAPHY_DATA</code> table
* (If necessary) upload the Cross_reference_forprogram.xlxs spreadsheet.
** Change the "# pages" column heading to "pages".
** Change the "Group comp problem?" column heading to "Group comp problem".
** Export it from Excel as csv
** Upload into the cross_reference_forprogram table.
* Export the following tables from Access as csv files:
** follow
** follow_1_minute
** follow_1_minute_infant
** follow_1_minute_mother
** follow_1_minute_sibling
** follow_5_minute
** follow_5_minute_group
* Delete all rows from the following tables in the <code>conversion</code> schema (if necessary), in the following order:
** follow_5_minute_group
** follow_5_minute
** follow_1_minute_sibling
** follow_1_minute_mother
** follow_1_minute_infant
** follow_1_minute
** follow_1_minute
* Import the Access csv files into their corresponding tables in the <code>conversion</code> schema.  Import in order of creation as listed above.
* Prepare the Access data for conversion by running <code>prepare_data()</code> as follows: <br/><code>select prepare_data();</code>
* Use convert_access() to convert a desired time period, the dates are inclusive.  Repeat as necessary with different time periods.  If you get an error the database is unchanged. <br/> <code>select convert_access('1990-01-01', '1990-12-31');</code>
* Fix errors in the data and repeat.

== Obtaining Multiple Errors ==

The <code>convert_access()</code> program stops as soon as it finds an error,
in which case the data in the database remains untouched.  If there are many errors in the data it can be tedious converting many days with a single invocation of <code>convert_access()</code>, fixing a single error, and repeating.  The solution is to run the program many times, and, regardless of error or lack thereof, discard all changes to the database so that the process can be repeated as many times as desired.

The following example code can be cut and paste to find up to an error per day within entire year's worth of data.  Cutting and pasting the example, together with a little search and replace, and attention to leap year, can adapt it to any year or to multiple years.

<pre>
begin; select convert_access('1996-01-01', '1996-01-01'); rollback;
begin; select convert_access('1996-01-02', '1996-01-02'); rollback;
begin; select convert_access('1996-01-03', '1996-01-03'); rollback;
begin; select convert_access('1996-01-04', '1996-01-04'); rollback;
begin; select convert_access('1996-01-05', '1996-01-05'); rollback;
begin; select convert_access('1996-01-06', '1996-01-06'); rollback;
begin; select convert_access('1996-01-07', '1996-01-07'); rollback;
begin; select convert_access('1996-01-08', '1996-01-08'); rollback;
begin; select convert_access('1996-01-09', '1996-01-09'); rollback;
begin; select convert_access('1996-01-10', '1996-01-10'); rollback;
begin; select convert_access('1996-01-11', '1996-01-11'); rollback;
begin; select convert_access('1996-01-12', '1996-01-12'); rollback;
begin; select convert_access('1996-01-13', '1996-01-13'); rollback;
begin; select convert_access('1996-01-14', '1996-01-14'); rollback;
begin; select convert_access('1996-01-15', '1996-01-15'); rollback;
begin; select convert_access('1996-01-16', '1996-01-16'); rollback;
begin; select convert_access('1996-01-17', '1996-01-17'); rollback;
begin; select convert_access('1996-01-18', '1996-01-18'); rollback;
begin; select convert_access('1996-01-19', '1996-01-19'); rollback;
begin; select convert_access('1996-01-20', '1996-01-20'); rollback;
begin; select convert_access('1996-01-21', '1996-01-21'); rollback;
begin; select convert_access('1996-01-22', '1996-01-22'); rollback;
begin; select convert_access('1996-01-23', '1996-01-23'); rollback;
begin; select convert_access('1996-01-24', '1996-01-24'); rollback;
begin; select convert_access('1996-01-25', '1996-01-25'); rollback;
begin; select convert_access('1996-01-26', '1996-01-26'); rollback;
begin; select convert_access('1996-01-27', '1996-01-27'); rollback;
begin; select convert_access('1996-01-28', '1996-01-28'); rollback;
begin; select convert_access('1996-01-29', '1996-01-29'); rollback;
begin; select convert_access('1996-01-30', '1996-01-30'); rollback;
begin; select convert_access('1996-01-31', '1996-01-31'); rollback;
begin; select convert_access('1996-02-01', '1996-02-01'); rollback;
begin; select convert_access('1996-02-02', '1996-02-02'); rollback;
begin; select convert_access('1996-02-03', '1996-02-03'); rollback;
begin; select convert_access('1996-02-04', '1996-02-04'); rollback;
begin; select convert_access('1996-02-05', '1996-02-05'); rollback;
begin; select convert_access('1996-02-06', '1996-02-06'); rollback;
begin; select convert_access('1996-02-07', '1996-02-07'); rollback;
begin; select convert_access('1996-02-08', '1996-02-08'); rollback;
begin; select convert_access('1996-02-09', '1996-02-09'); rollback;
begin; select convert_access('1996-02-10', '1996-02-10'); rollback;
begin; select convert_access('1996-02-11', '1996-02-11'); rollback;
begin; select convert_access('1996-02-12', '1996-02-12'); rollback;
begin; select convert_access('1996-02-13', '1996-02-13'); rollback;
begin; select convert_access('1996-02-14', '1996-02-14'); rollback;
begin; select convert_access('1996-02-15', '1996-02-15'); rollback;
begin; select convert_access('1996-02-16', '1996-02-16'); rollback;
begin; select convert_access('1996-02-17', '1996-02-17'); rollback;
begin; select convert_access('1996-02-18', '1996-02-18'); rollback;
begin; select convert_access('1996-02-19', '1996-02-19'); rollback;
begin; select convert_access('1996-02-20', '1996-02-20'); rollback;
begin; select convert_access('1996-02-21', '1996-02-21'); rollback;
begin; select convert_access('1996-02-22', '1996-02-22'); rollback;
begin; select convert_access('1996-02-23', '1996-02-23'); rollback;
begin; select convert_access('1996-02-24', '1996-02-24'); rollback;
begin; select convert_access('1996-02-25', '1996-02-25'); rollback;
begin; select convert_access('1996-02-26', '1996-02-26'); rollback;
begin; select convert_access('1996-02-27', '1996-02-27'); rollback;
begin; select convert_access('1996-02-28', '1996-02-28'); rollback;
begin; select convert_access('1996-02-29', '1996-02-29'); rollback;
begin; select convert_access('1996-03-01', '1996-03-01'); rollback;
begin; select convert_access('1996-03-02', '1996-03-02'); rollback;
begin; select convert_access('1996-03-03', '1996-03-03'); rollback;
begin; select convert_access('1996-03-04', '1996-03-04'); rollback;
begin; select convert_access('1996-03-05', '1996-03-05'); rollback;
begin; select convert_access('1996-03-06', '1996-03-06'); rollback;
begin; select convert_access('1996-03-07', '1996-03-07'); rollback;
begin; select convert_access('1996-03-08', '1996-03-08'); rollback;
begin; select convert_access('1996-03-09', '1996-03-09'); rollback;
begin; select convert_access('1996-03-10', '1996-03-10'); rollback;
begin; select convert_access('1996-03-11', '1996-03-11'); rollback;
begin; select convert_access('1996-03-12', '1996-03-12'); rollback;
begin; select convert_access('1996-03-13', '1996-03-13'); rollback;
begin; select convert_access('1996-03-14', '1996-03-14'); rollback;
begin; select convert_access('1996-03-15', '1996-03-15'); rollback;
begin; select convert_access('1996-03-16', '1996-03-16'); rollback;
begin; select convert_access('1996-03-17', '1996-03-17'); rollback;
begin; select convert_access('1996-03-18', '1996-03-18'); rollback;
begin; select convert_access('1996-03-19', '1996-03-19'); rollback;
begin; select convert_access('1996-03-20', '1996-03-20'); rollback;
begin; select convert_access('1996-03-21', '1996-03-21'); rollback;
begin; select convert_access('1996-03-22', '1996-03-22'); rollback;
begin; select convert_access('1996-03-23', '1996-03-23'); rollback;
begin; select convert_access('1996-03-24', '1996-03-24'); rollback;
begin; select convert_access('1996-03-25', '1996-03-25'); rollback;
begin; select convert_access('1996-03-26', '1996-03-26'); rollback;
begin; select convert_access('1996-03-27', '1996-03-27'); rollback;
begin; select convert_access('1996-03-28', '1996-03-28'); rollback;
begin; select convert_access('1996-03-29', '1996-03-29'); rollback;
begin; select convert_access('1996-03-30', '1996-03-30'); rollback;
begin; select convert_access('1996-03-31', '1996-03-31'); rollback;
begin; select convert_access('1996-04-01', '1996-04-01'); rollback;
begin; select convert_access('1996-04-02', '1996-04-02'); rollback;
begin; select convert_access('1996-04-03', '1996-04-03'); rollback;
begin; select convert_access('1996-04-04', '1996-04-04'); rollback;
begin; select convert_access('1996-04-05', '1996-04-05'); rollback;
begin; select convert_access('1996-04-06', '1996-04-06'); rollback;
begin; select convert_access('1996-04-07', '1996-04-07'); rollback;
begin; select convert_access('1996-04-08', '1996-04-08'); rollback;
begin; select convert_access('1996-04-09', '1996-04-09'); rollback;
begin; select convert_access('1996-04-10', '1996-04-10'); rollback;
begin; select convert_access('1996-04-11', '1996-04-11'); rollback;
begin; select convert_access('1996-04-12', '1996-04-12'); rollback;
begin; select convert_access('1996-04-13', '1996-04-13'); rollback;
begin; select convert_access('1996-04-14', '1996-04-14'); rollback;
begin; select convert_access('1996-04-15', '1996-04-15'); rollback;
begin; select convert_access('1996-04-16', '1996-04-16'); rollback;
begin; select convert_access('1996-04-17', '1996-04-17'); rollback;
begin; select convert_access('1996-04-18', '1996-04-18'); rollback;
begin; select convert_access('1996-04-19', '1996-04-19'); rollback;
begin; select convert_access('1996-04-20', '1996-04-20'); rollback;
begin; select convert_access('1996-04-21', '1996-04-21'); rollback;
begin; select convert_access('1996-04-22', '1996-04-22'); rollback;
begin; select convert_access('1996-04-23', '1996-04-23'); rollback;
begin; select convert_access('1996-04-24', '1996-04-24'); rollback;
begin; select convert_access('1996-04-25', '1996-04-25'); rollback;
begin; select convert_access('1996-04-26', '1996-04-26'); rollback;
begin; select convert_access('1996-04-27', '1996-04-27'); rollback;
begin; select convert_access('1996-04-28', '1996-04-28'); rollback;
begin; select convert_access('1996-04-29', '1996-04-29'); rollback;
begin; select convert_access('1996-04-30', '1996-04-30'); rollback;
begin; select convert_access('1996-05-01', '1996-05-01'); rollback;
begin; select convert_access('1996-05-02', '1996-05-02'); rollback;
begin; select convert_access('1996-05-03', '1996-05-03'); rollback;
begin; select convert_access('1996-05-04', '1996-05-04'); rollback;
begin; select convert_access('1996-05-05', '1996-05-05'); rollback;
begin; select convert_access('1996-05-06', '1996-05-06'); rollback;
begin; select convert_access('1996-05-07', '1996-05-07'); rollback;
begin; select convert_access('1996-05-08', '1996-05-08'); rollback;
begin; select convert_access('1996-05-09', '1996-05-09'); rollback;
begin; select convert_access('1996-05-10', '1996-05-10'); rollback;
begin; select convert_access('1996-05-11', '1996-05-11'); rollback;
begin; select convert_access('1996-05-12', '1996-05-12'); rollback;
begin; select convert_access('1996-05-13', '1996-05-13'); rollback;
begin; select convert_access('1996-05-14', '1996-05-14'); rollback;
begin; select convert_access('1996-05-15', '1996-05-15'); rollback;
begin; select convert_access('1996-05-16', '1996-05-16'); rollback;
begin; select convert_access('1996-05-17', '1996-05-17'); rollback;
begin; select convert_access('1996-05-18', '1996-05-18'); rollback;
begin; select convert_access('1996-05-19', '1996-05-19'); rollback;
begin; select convert_access('1996-05-20', '1996-05-20'); rollback;
begin; select convert_access('1996-05-21', '1996-05-21'); rollback;
begin; select convert_access('1996-05-22', '1996-05-22'); rollback;
begin; select convert_access('1996-05-23', '1996-05-23'); rollback;
begin; select convert_access('1996-05-24', '1996-05-24'); rollback;
begin; select convert_access('1996-05-25', '1996-05-25'); rollback;
begin; select convert_access('1996-05-26', '1996-05-26'); rollback;
begin; select convert_access('1996-05-27', '1996-05-27'); rollback;
begin; select convert_access('1996-05-28', '1996-05-28'); rollback;
begin; select convert_access('1996-05-29', '1996-05-29'); rollback;
begin; select convert_access('1996-05-30', '1996-05-30'); rollback;
begin; select convert_access('1996-05-31', '1996-05-31'); rollback;
begin; select convert_access('1996-06-01', '1996-06-01'); rollback;
begin; select convert_access('1996-06-02', '1996-06-02'); rollback;
begin; select convert_access('1996-06-03', '1996-06-03'); rollback;
begin; select convert_access('1996-06-04', '1996-06-04'); rollback;
begin; select convert_access('1996-06-05', '1996-06-05'); rollback;
begin; select convert_access('1996-06-06', '1996-06-06'); rollback;
begin; select convert_access('1996-06-07', '1996-06-07'); rollback;
begin; select convert_access('1996-06-08', '1996-06-08'); rollback;
begin; select convert_access('1996-06-09', '1996-06-09'); rollback;
begin; select convert_access('1996-06-10', '1996-06-10'); rollback;
begin; select convert_access('1996-06-11', '1996-06-11'); rollback;
begin; select convert_access('1996-06-12', '1996-06-12'); rollback;
begin; select convert_access('1996-06-13', '1996-06-13'); rollback;
begin; select convert_access('1996-06-14', '1996-06-14'); rollback;
begin; select convert_access('1996-06-15', '1996-06-15'); rollback;
begin; select convert_access('1996-06-16', '1996-06-16'); rollback;
begin; select convert_access('1996-06-17', '1996-06-17'); rollback;
begin; select convert_access('1996-06-18', '1996-06-18'); rollback;
begin; select convert_access('1996-06-19', '1996-06-19'); rollback;
begin; select convert_access('1996-06-20', '1996-06-20'); rollback;
begin; select convert_access('1996-06-21', '1996-06-21'); rollback;
begin; select convert_access('1996-06-22', '1996-06-22'); rollback;
begin; select convert_access('1996-06-23', '1996-06-23'); rollback;
begin; select convert_access('1996-06-24', '1996-06-24'); rollback;
begin; select convert_access('1996-06-25', '1996-06-25'); rollback;
begin; select convert_access('1996-06-26', '1996-06-26'); rollback;
begin; select convert_access('1996-06-27', '1996-06-27'); rollback;
begin; select convert_access('1996-06-28', '1996-06-28'); rollback;
begin; select convert_access('1996-06-29', '1996-06-29'); rollback;
begin; select convert_access('1996-06-30', '1996-06-30'); rollback;
begin; select convert_access('1996-07-01', '1996-07-01'); rollback;
begin; select convert_access('1996-07-02', '1996-07-02'); rollback;
begin; select convert_access('1996-07-03', '1996-07-03'); rollback;
begin; select convert_access('1996-07-04', '1996-07-04'); rollback;
begin; select convert_access('1996-07-05', '1996-07-05'); rollback;
begin; select convert_access('1996-07-06', '1996-07-06'); rollback;
begin; select convert_access('1996-07-07', '1996-07-07'); rollback;
begin; select convert_access('1996-07-08', '1996-07-08'); rollback;
begin; select convert_access('1996-07-09', '1996-07-09'); rollback;
begin; select convert_access('1996-07-10', '1996-07-10'); rollback;
begin; select convert_access('1996-07-11', '1996-07-11'); rollback;
begin; select convert_access('1996-07-12', '1996-07-12'); rollback;
begin; select convert_access('1996-07-13', '1996-07-13'); rollback;
begin; select convert_access('1996-07-14', '1996-07-14'); rollback;
begin; select convert_access('1996-07-15', '1996-07-15'); rollback;
begin; select convert_access('1996-07-16', '1996-07-16'); rollback;
begin; select convert_access('1996-07-17', '1996-07-17'); rollback;
begin; select convert_access('1996-07-18', '1996-07-18'); rollback;
begin; select convert_access('1996-07-19', '1996-07-19'); rollback;
begin; select convert_access('1996-07-20', '1996-07-20'); rollback;
begin; select convert_access('1996-07-21', '1996-07-21'); rollback;
begin; select convert_access('1996-07-22', '1996-07-22'); rollback;
begin; select convert_access('1996-07-23', '1996-07-23'); rollback;
begin; select convert_access('1996-07-24', '1996-07-24'); rollback;
begin; select convert_access('1996-07-25', '1996-07-25'); rollback;
begin; select convert_access('1996-07-26', '1996-07-26'); rollback;
begin; select convert_access('1996-07-27', '1996-07-27'); rollback;
begin; select convert_access('1996-07-28', '1996-07-28'); rollback;
begin; select convert_access('1996-07-29', '1996-07-29'); rollback;
begin; select convert_access('1996-07-30', '1996-07-30'); rollback;
begin; select convert_access('1996-07-31', '1996-07-31'); rollback;
begin; select convert_access('1996-08-01', '1996-08-01'); rollback;
begin; select convert_access('1996-08-02', '1996-08-02'); rollback;
begin; select convert_access('1996-08-03', '1996-08-03'); rollback;
begin; select convert_access('1996-08-04', '1996-08-04'); rollback;
begin; select convert_access('1996-08-05', '1996-08-05'); rollback;
begin; select convert_access('1996-08-06', '1996-08-06'); rollback;
begin; select convert_access('1996-08-07', '1996-08-07'); rollback;
begin; select convert_access('1996-08-08', '1996-08-08'); rollback;
begin; select convert_access('1996-08-09', '1996-08-09'); rollback;
begin; select convert_access('1996-08-10', '1996-08-10'); rollback;
begin; select convert_access('1996-08-11', '1996-08-11'); rollback;
begin; select convert_access('1996-08-12', '1996-08-12'); rollback;
begin; select convert_access('1996-08-13', '1996-08-13'); rollback;
begin; select convert_access('1996-08-14', '1996-08-14'); rollback;
begin; select convert_access('1996-08-15', '1996-08-15'); rollback;
begin; select convert_access('1996-08-16', '1996-08-16'); rollback;
begin; select convert_access('1996-08-17', '1996-08-17'); rollback;
begin; select convert_access('1996-08-18', '1996-08-18'); rollback;
begin; select convert_access('1996-08-19', '1996-08-19'); rollback;
begin; select convert_access('1996-08-20', '1996-08-20'); rollback;
begin; select convert_access('1996-08-21', '1996-08-21'); rollback;
begin; select convert_access('1996-08-22', '1996-08-22'); rollback;
begin; select convert_access('1996-08-23', '1996-08-23'); rollback;
begin; select convert_access('1996-08-24', '1996-08-24'); rollback;
begin; select convert_access('1996-08-25', '1996-08-25'); rollback;
begin; select convert_access('1996-08-26', '1996-08-26'); rollback;
begin; select convert_access('1996-08-27', '1996-08-27'); rollback;
begin; select convert_access('1996-08-28', '1996-08-28'); rollback;
begin; select convert_access('1996-08-29', '1996-08-29'); rollback;
begin; select convert_access('1996-08-30', '1996-08-30'); rollback;
begin; select convert_access('1996-08-31', '1996-08-31'); rollback;
begin; select convert_access('1996-09-01', '1996-09-01'); rollback;
begin; select convert_access('1996-09-02', '1996-09-02'); rollback;
begin; select convert_access('1996-09-03', '1996-09-03'); rollback;
begin; select convert_access('1996-09-04', '1996-09-04'); rollback;
begin; select convert_access('1996-09-05', '1996-09-05'); rollback;
begin; select convert_access('1996-09-06', '1996-09-06'); rollback;
begin; select convert_access('1996-09-07', '1996-09-07'); rollback;
begin; select convert_access('1996-09-08', '1996-09-08'); rollback;
begin; select convert_access('1996-09-09', '1996-09-09'); rollback;
begin; select convert_access('1996-09-10', '1996-09-10'); rollback;
begin; select convert_access('1996-09-11', '1996-09-11'); rollback;
begin; select convert_access('1996-09-12', '1996-09-12'); rollback;
begin; select convert_access('1996-09-13', '1996-09-13'); rollback;
begin; select convert_access('1996-09-14', '1996-09-14'); rollback;
begin; select convert_access('1996-09-15', '1996-09-15'); rollback;
begin; select convert_access('1996-09-16', '1996-09-16'); rollback;
begin; select convert_access('1996-09-17', '1996-09-17'); rollback;
begin; select convert_access('1996-09-18', '1996-09-18'); rollback;
begin; select convert_access('1996-09-19', '1996-09-19'); rollback;
begin; select convert_access('1996-09-20', '1996-09-20'); rollback;
begin; select convert_access('1996-09-21', '1996-09-21'); rollback;
begin; select convert_access('1996-09-22', '1996-09-22'); rollback;
begin; select convert_access('1996-09-23', '1996-09-23'); rollback;
begin; select convert_access('1996-09-24', '1996-09-24'); rollback;
begin; select convert_access('1996-09-25', '1996-09-25'); rollback;
begin; select convert_access('1996-09-26', '1996-09-26'); rollback;
begin; select convert_access('1996-09-27', '1996-09-27'); rollback;
begin; select convert_access('1996-09-28', '1996-09-28'); rollback;
begin; select convert_access('1996-09-29', '1996-09-29'); rollback;
begin; select convert_access('1996-09-30', '1996-09-30'); rollback;
begin; select convert_access('1996-10-01', '1996-10-01'); rollback;
begin; select convert_access('1996-10-02', '1996-10-02'); rollback;
begin; select convert_access('1996-10-03', '1996-10-03'); rollback;
begin; select convert_access('1996-10-04', '1996-10-04'); rollback;
begin; select convert_access('1996-10-05', '1996-10-05'); rollback;
begin; select convert_access('1996-10-06', '1996-10-06'); rollback;
begin; select convert_access('1996-10-07', '1996-10-07'); rollback;
begin; select convert_access('1996-10-08', '1996-10-08'); rollback;
begin; select convert_access('1996-10-09', '1996-10-09'); rollback;
begin; select convert_access('1996-10-10', '1996-10-10'); rollback;
begin; select convert_access('1996-10-11', '1996-10-11'); rollback;
begin; select convert_access('1996-10-12', '1996-10-12'); rollback;
begin; select convert_access('1996-10-13', '1996-10-13'); rollback;
begin; select convert_access('1996-10-14', '1996-10-14'); rollback;
begin; select convert_access('1996-10-15', '1996-10-15'); rollback;
begin; select convert_access('1996-10-16', '1996-10-16'); rollback;
begin; select convert_access('1996-10-17', '1996-10-17'); rollback;
begin; select convert_access('1996-10-18', '1996-10-18'); rollback;
begin; select convert_access('1996-10-19', '1996-10-19'); rollback;
begin; select convert_access('1996-10-20', '1996-10-20'); rollback;
begin; select convert_access('1996-10-21', '1996-10-21'); rollback;
begin; select convert_access('1996-10-22', '1996-10-22'); rollback;
begin; select convert_access('1996-10-23', '1996-10-23'); rollback;
begin; select convert_access('1996-10-24', '1996-10-24'); rollback;
begin; select convert_access('1996-10-25', '1996-10-25'); rollback;
begin; select convert_access('1996-10-26', '1996-10-26'); rollback;
begin; select convert_access('1996-10-27', '1996-10-27'); rollback;
begin; select convert_access('1996-10-28', '1996-10-28'); rollback;
begin; select convert_access('1996-10-29', '1996-10-29'); rollback;
begin; select convert_access('1996-10-30', '1996-10-30'); rollback;
begin; select convert_access('1996-10-31', '1996-10-31'); rollback;
begin; select convert_access('1996-11-01', '1996-11-01'); rollback;
begin; select convert_access('1996-11-02', '1996-11-02'); rollback;
begin; select convert_access('1996-11-03', '1996-11-03'); rollback;
begin; select convert_access('1996-11-04', '1996-11-04'); rollback;
begin; select convert_access('1996-11-05', '1996-11-05'); rollback;
begin; select convert_access('1996-11-06', '1996-11-06'); rollback;
begin; select convert_access('1996-11-07', '1996-11-07'); rollback;
begin; select convert_access('1996-11-08', '1996-11-08'); rollback;
begin; select convert_access('1996-11-09', '1996-11-09'); rollback;
begin; select convert_access('1996-11-10', '1996-11-10'); rollback;
begin; select convert_access('1996-11-11', '1996-11-11'); rollback;
begin; select convert_access('1996-11-12', '1996-11-12'); rollback;
begin; select convert_access('1996-11-13', '1996-11-13'); rollback;
begin; select convert_access('1996-11-14', '1996-11-14'); rollback;
begin; select convert_access('1996-11-15', '1996-11-15'); rollback;
begin; select convert_access('1996-11-16', '1996-11-16'); rollback;
begin; select convert_access('1996-11-17', '1996-11-17'); rollback;
begin; select convert_access('1996-11-18', '1996-11-18'); rollback;
begin; select convert_access('1996-11-19', '1996-11-19'); rollback;
begin; select convert_access('1996-11-20', '1996-11-20'); rollback;
begin; select convert_access('1996-11-21', '1996-11-21'); rollback;
begin; select convert_access('1996-11-22', '1996-11-22'); rollback;
begin; select convert_access('1996-11-23', '1996-11-23'); rollback;
begin; select convert_access('1996-11-24', '1996-11-24'); rollback;
begin; select convert_access('1996-11-25', '1996-11-25'); rollback;
begin; select convert_access('1996-11-26', '1996-11-26'); rollback;
begin; select convert_access('1996-11-27', '1996-11-27'); rollback;
begin; select convert_access('1996-11-28', '1996-11-28'); rollback;
begin; select convert_access('1996-11-29', '1996-11-29'); rollback;
begin; select convert_access('1996-11-30', '1996-11-30'); rollback;
begin; select convert_access('1996-12-01', '1996-12-01'); rollback;
begin; select convert_access('1996-12-02', '1996-12-02'); rollback;
begin; select convert_access('1996-12-03', '1996-12-03'); rollback;
begin; select convert_access('1996-12-04', '1996-12-04'); rollback;
begin; select convert_access('1996-12-05', '1996-12-05'); rollback;
begin; select convert_access('1996-12-06', '1996-12-06'); rollback;
begin; select convert_access('1996-12-07', '1996-12-07'); rollback;
begin; select convert_access('1996-12-08', '1996-12-08'); rollback;
begin; select convert_access('1996-12-09', '1996-12-09'); rollback;
begin; select convert_access('1996-12-10', '1996-12-10'); rollback;
begin; select convert_access('1996-12-11', '1996-12-11'); rollback;
begin; select convert_access('1996-12-12', '1996-12-12'); rollback;
begin; select convert_access('1996-12-13', '1996-12-13'); rollback;
begin; select convert_access('1996-12-14', '1996-12-14'); rollback;
begin; select convert_access('1996-12-15', '1996-12-15'); rollback;
begin; select convert_access('1996-12-16', '1996-12-16'); rollback;
begin; select convert_access('1996-12-17', '1996-12-17'); rollback;
begin; select convert_access('1996-12-18', '1996-12-18'); rollback;
begin; select convert_access('1996-12-19', '1996-12-19'); rollback;
begin; select convert_access('1996-12-20', '1996-12-20'); rollback;
begin; select convert_access('1996-12-21', '1996-12-21'); rollback;
begin; select convert_access('1996-12-22', '1996-12-22'); rollback;
begin; select convert_access('1996-12-23', '1996-12-23'); rollback;
begin; select convert_access('1996-12-24', '1996-12-24'); rollback;
begin; select convert_access('1996-12-25', '1996-12-25'); rollback;
begin; select convert_access('1996-12-26', '1996-12-26'); rollback;
begin; select convert_access('1996-12-27', '1996-12-27'); rollback;
begin; select convert_access('1996-12-28', '1996-12-28'); rollback;
begin; select convert_access('1996-12-29', '1996-12-29'); rollback;
begin; select convert_access('1996-12-30', '1996-12-30'); rollback;
begin; select convert_access('1996-12-31', '1996-12-31'); rollback;
</pre>