ACS3 Data Model

     1: function mv_first_of_month
     2: return date
     3: as
     4:  current_year varchar(30);
     5:  current_month varchar(30);
     6: begin
     7:   current_year := to_char(sysdate,'YYYY');
     8:   current_month := to_char(sysdate,'MM');
     9:   return to_date(current_year || '-' || current_month || '-01 00:00:00','YYYY-MM-DD HH24:MI:SS');
    10: end mv_first_of_month;