Re: date functions

Originally posted by Macius The Great
> hello :)
>
> is here someone who can tell me how to get numbers of days in month
> simply function which return numbers of days in mounth
> or maybe how to find prices form table:
>
> table :
>
> price | effective_start_date| effective_end_date
>
> I need select all prices efecctive in month of may
> I mean :
>
> ended in may
> started and ended in may
> started in may
>
> any simple solution?
>
> regards
>
> MK
TRUNC(date1,'MM') returns the 1st of the month for date1 LAST_DAY(date1) returns the last day of the month

Does that help?

--
Posted via http://dbforums.com