OraFAQ Forum: SQL & PL/SQL » how to find number of days in a given month.

Home » SQL & PL/SQL » SQL & PL/SQL » how to find number of days in a given month. (SQL PLUS ORACLE 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find number of days in a given month. [message #607469]

Fri, 07 February 2014 00:56

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

i want to find number of days in a given month, that means if if provide value 'march' then it should display 31 days ,if 'february' then 28or29 days .
Please tell how to do that.

Report message to a moderator

Re: how to find number of days in a given month. [message #607470 is a reply to message #607469]

Fri, 07 February 2014 00:57

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Now when you want 28 or 29, I will say manually do it, use case statement.

Manu

Report message to a moderator

Re: how to find number of days in a given month. [message #607471 is a reply to message #607470]

Fri, 07 February 2014 01:06

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

NO THATS NOT MY REQUIREMENT , MY REQUIREMENT IS LIKE THIS:-
SELECT NO_OF_DAYS FROM DUAL
WHERE TO_CHAR(SYSDATE,'MONTH')='MONTH_NAME';

Report message to a moderator

Re: how to find number of days in a given month. [message #607472 is a reply to message #607471]

Fri, 07 February 2014 01:15

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

You are expecting something like this:

SQL> select to_char(add_months(trunc(sysdate,'month'),1)-1,'dd') last_date from dual;

LA
--
28

Manu

Report message to a moderator

Re: how to find number of days in a given month. [message #607474 is a reply to message #607472]

Fri, 07 February 2014 01:26

_jum
Messages: 577
Registered: February 2008

Senior Member

you could use last_day function also, here an example that works for the "current year" (february differs bec. of leap year):

SELECT TO_CHAR(LAST_DAY(TO_DATE('february', 'month')),'dd') FROM dual;

28                                                                         
1 row selected.


SELECT TO_CHAR(LAST_DAY(TO_DATE('march', 'month')),'dd') FROM dual;

31                                                                         
1 row selected.

With year:

SELECT TO_CHAR(LAST_DAY(TO_DATE('2016/february', 'yyyy/month')),'dd') FROM dual;

29                                                      
1 row selected.

[Updated on: Fri, 07 February 2014 01:31]

Report message to a moderator

Re: how to find number of days in a given month. [message #607475 is a reply to message #607474]

Fri, 07 February 2014 01:34

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

LOL SO EASY ,THANKS BUDDY Smile

Report message to a moderator

Previous Topic:	user creation
Next Topic:	parse blob into rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:49:22 CDT 2024