oracle8.1.6 select user_id, member_state, email_verified_p, trunc(sysdate - password_changed_date) as password_age_days from cc_users where email = :email