Add psycopg2 type overrides to DBAPI

So these tests won't check that isoformat is the correct way to send a date, or "%H:%M:%S" is the correct way to send a time, just that it's consistent between production and test code. I guess asserting the value probably since it's just a copy of the production code in the test.