5 SELECT col_type_is('actor', 'usr', 'dob', 'date', 'Check dob column type');
9 '2011-02-28 23:00:00-05'::timestamptz + '3 hours'::interval)::date),
11 'Confirming date translation on hour-23 dates'
15 (SELECT dob FROM actor.usr WHERE id = 1),
16 '1979-01-22', -- DoB of admin user
17 'Checking admin default dob'
20 UPDATE actor.usr SET dob = '2011-03-01 00:00:00-10' WHERE id = 1;
23 (SELECT dob FROM actor.usr WHERE id = 1),
25 'Date truncation with timezone v1'
28 UPDATE actor.usr SET dob = '2011-06-01 00:00:00+10' WHERE id = 1;
31 (SELECT dob FROM actor.usr WHERE id = 1),
33 'Date truncation with timezone v2'
36 -- Finish the tests and clean up.
37 SELECT * FROM finish();