Re: How to get the end value of month

Prateek Jain wrote: > Hi, > I want to execute query for that i require end date of the month, > > suppose if the month is April then it should return 30 > if March then in should return 31 > Is there any inbuilt function for that which give the end date of the month Download June Hunt's presentation at the IIUG/IDUG User Conference last week on SQL from the IIUG Web site. She deals with several of these type of queries and time calculations there. You all should have been there! Art S. Kagel