changed the datatypes for date columns from date to timestamp in promotion related tables