Member Avatar for 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.

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by tesuji
Member Avatar for tesuji

Hi,

you may try:

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

krs,
tesu

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.