Get all the months that have 31 days

[tanta]

Hi,
I am a junior dev. and I need help on some select statements on a Oracle db.
First I needed to get all the months of the year in 'MON' format and I did it like this:

SELECT distinct TO_CHAR(dt,'MON') MONTH
FROM ( SELECT TRUNC(SYSDATE,'y')-1+ROWNUM dt
FROM all_objects
WHERE ROWNUM <= 366)
ORDER BY TO_DATE( MONTH, 'MON' )

Now, I need another statements to get only the month that have 31 days, then 30 days the leap year.

I cannot create strings that have the names like JANFEBMAR.. and then compare because we use this in a multilingual environment.

Any help would be appreciate it.

[tesuji]

Hi,

you may try:

select * from yourtable where TO_CHAR(your_date, 'MM') in ('01', '03',... ,'12')

krs,
tesu