How to obtain the Sunday date of the current date

How to obtain the Java code www.2cto.com update DIM_TIME f set f. firstday_of_week = case when f. full_date <round (f. full_date, 'day') then to_char (round (f. full_date, 'day')-7, 'yyyy-mm-dd') else to_char (round (f. full_date, 'day'), 'yyyy-mm-dd') end where f. year <2012 check whether the updated version is correct www.2cto.com Java code select f. firstday_of_week, case when f. full_date <round (f. full_date, 'day') then to_char (round (f. full_date, 'day')-7, 'yyyy-mm-dd') else to_char (round (f. full_date, 'day'), 'yyyy-mm-dd') end from dim_time f where f. year <2012;