[Home] [Help]
172: begin
173:
174: select to_number(to_char(to_date(p_date1, 'j'), 'MM'))
175: INTO
176: month1 from dual;
177:
178:
179: select to_number(to_char(to_date(p_date2, 'j'), 'MM'))
180: INTO
177:
178:
179: select to_number(to_char(to_date(p_date2, 'j'), 'MM'))
180: INTO
181: month2 from dual;
182:
183:
184: if(month1 <> month2)
185: then
199: begin
200:
201: select to_char(to_date(p_date, 'j'), 'D')
202: into
203: day_of_week from dual;
204:
205:
206: return day_of_week;
207: end;
232: select
233: to_number(to_char(last_day(to_date(the_date, 'J')), 'J'))
234: into
235: last_day_of_mth
236: from dual;
237:
238: /*--------------------------------------------------+
239: | If last day of month falls on weekend, please |
240: | set it accordingly for 5-2 calendar |
704: +-------------------------------------------------------*/
705:
706: select sysdate
707: into first_date
708: from dual;
709:
710: select to_number(to_char(first_date, 'J'))
711: into jul_first_date
712: from dual;
708: from dual;
709:
710: select to_number(to_char(first_date, 'J'))
711: into jul_first_date
712: from dual;
713:
714: /*-------------------------------------------------------+
715: | Get calendar code from the table msc_plan_organizations|
716: | At present the code is defined at the plan level, so |
973: made this change to resolve GSCC warnings
974: -- select to_number(to_char(to_date('1' ||'-' || to_char (sysdate ,'MON-YYYY')), 'j'))
975: select to_number(to_char(sysdate,'j') )
976: into l_start_date
977: from dual;
978:
979: l_curr_date := l_start_date;
980:
981: loop
1123:
1124: select to_number(to_char(last_day(to_date(l_curr_date, 'j')), 'j'))
1125: into
1126: l_bkt_end_date
1127: from dual;
1128:
1129:
1130: --------------------------------------+
1131: | Bucket is month. Create monthly bucket|