date; time

character(10); character(20)

"2011-04-20";"13:25:36.026-07:00  "

datetime; timezone

timestamp without timezone; time interval

to_timestamp(a.date||' '||substring(a.time from 0 for 13), 'YYYY-MM-DD HH24:MI:SS' ) at time zone 'AST'