FIRST_DAY

[ballboas]

I can not understand how an Oracle size company did not have the ability to think of a function like that. After last_day, I'll introduce you to First_Day.

Select all

 
create or replace 
FUNCTION FIRST_DAY (pDATA IN DATE DEFAULT SYSDATE) RETURN DATE AS 
begin 
  --Retorna o primeiro dia do mês passado no parâmetro 
  RETURN last_day(add_months(pDATA,-1))+1; 
END FIRST_DAY; 

to test ....

Select all

 
SQL> select first_day(sysdate) 
  2  ,      last_day(sysdate) 
  3  from   dual 
  4  / 
 
FIRST_DAY(SYSDATE) LAST_DAY(SYSDATE) 
------------------ ----------------- 
01/03/2011       31/03/2011 

found in the environment of production.

[ishii]

Hello,

You could use the trunca too ...

Select all

SQL> select trunc(sysdate,'mm')  
  2  ,      last_day(sysdate)  
  3  from   dual  
  4  /  

should work the same way ....

[] S ISHII

[burga]

Genius!!! : -The

: lol:: lol :: lol:

[ballboas]

The time that I find the genius that bolou this function I give a touch .... hehehehe ...

[dr_gori]

In the old days, when I did not know the Trunc (Sysdate, 'mm'), I did this:

Select all

SQL> SELECT TO_DATE(  '01/'||TO_CHAR(SYSDATE, 'MM/YYYY') , 'DD/MM/YYYY')  
  2  FROM DUAL; 
 
TO_DATE( 
-------- 
01/03/11 
 
SQL> 

: OOPs:

99] Ahhh, good trainee times :-d

[ballboas]

In my simple and humble opinion, it's less dumb to do a first_day function, at least in your trainee times you already knew that the month seempre starts on day 01. hehe .....: D

[gfkauer]

I even see this in legacy codes.

is more common than they imagine.

But do not worry, always someone overcomes and does something more absurd than us ...