postgresql7.1
select round(date_part('epoch', now() - completed_datetime)) as cur_wait_time
from as_sessions
where session_id = :last_session_id
update as_assessments set
instructions=:instructions, consent_page=:consent_page
where assessment_id=:as_assessment_id
update as_assessments set
instructions=:instructions, consent_page=:consent_page
where assessment_id=:new_rev_id
update as_assessments set
instructions=:instructions, consent_page=:consent_page
where assessment_id=:new_rev_id