first day of the month

[ociruj]

hi there,

how can i get the first day of a month? is there a function for that..?

 

[sybaseguru]

Hi,

I do not think there is a function for it.

This one does last day of the Month so you can work out the first day of the month from it

select TO_CHAR(TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'MM') || '-01-' || TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'YYYY'), 'MM-DD-YYYY')-1, 'dd-mm-yyyy') from dual;

Good luck

 

[SantaMufasa]

Ociruj,

I presume you want a function that returns the spelled day of the week of the first day of the month for a given date, is that correct? If so, here is the code for such a function:

create or replace function first_day (date_in in date) return varchar2 is
begin
return to_char(to_date('01'||to_char(date_in,'-mon-yy'),'dd-mon-yy'),'DAY');
end;
/
Function created.

select first_day(sysdate) from dual;

MONDAY

Is that what you wanted? If not, could you please clarify.

Dave

 

[sem]

Oh, the answer is so easy

TRUNC(SYSDATE, 'MM') - the first day of current month

LAST_DAY(SYSDATE)+1 - the first day of the next month


Regards, Dima

 

[ociruj]

Thanks DIMA for your help.... Regards...