Re: date functions

U¿ytkownik "andrewst" <member14183_at_dbforums.com> napisa³ w wiadomo¶ci news:3037112.1056456726_at_dbforums.com...
>
> 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?
>
> --
that's it ! thanx :)

[Quoted] any sugestions about how to check if the date1 is before date2, can I use statment date1>'31-DEC-99' do I compare strings or dates ? Received on Tue Jun 24 2003 - 15:06:38 CEST