oracle8.1.7 SELECT percent_score, to_char(creation_datetime, :format) AS session_start, to_char(completed_datetime, :format) AS session_finish, round ((completed_datetime - creation_datetime)* 1440 ) as session_time FROM as_sessions s WHERE s.session_id = :session_id