postgresql7.3 SELECT percent_score, to_char(creation_datetime, :format) AS session_start, to_char(completed_datetime, :format) AS session_finish, round(date_part('epoch', completed_datetime - creation_datetime)) as session_time FROM as_sessions s WHERE s.session_id = :session_id