retrieve the time of patient 8773's hospial admission a year before.
select admissions.admittime from admissions where admissions.subject_id = 8773 and datetime(admissions.admittime,'start of year') = datetime(current_time,'start of year','-1 year')