Perhaps change
ALTER TABLE actor.usr ALTER dob TYPE date USING dob::date;
to
ALTER TABLE actor.usr ALTER dob TYPE date USING (dob + '12 hours')::date;
or similar?
Perhaps change
ALTER TABLE actor.usr ALTER dob TYPE date USING dob::date;
to
ALTER TABLE actor.usr ALTER dob TYPE date USING (dob + '12 hours')::date;
or similar?