you can try this. just add a month and subtract 1 day.

select date('2006-02-01') + 1 month - 1 days from dual

Thanks,

Bill

William Steiner
Old World Industries
Director of Financial Applications MBA
Phone: 847-559-2054
Email: [Email address protected]





"KAMAL " <db2udbdba-ezmlmshield-x43068854.[Email address protected]
10/27/2006 04:03 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Date function







Hi All,

How to get a maximum days from a month?
For ex: days of january 2003 we get result 31


Thanks in advance,
Kamal.





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page