当前日期的周日日期如何取得

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

检查一下更新的是否正确

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;