Re: date functions

thanx but this is short thinking :)
[Quoted] what if the price is actual form two years

U¿ytkownik "Scott Mattes" <Scott_at_TheMattesFamily.ws> napisa³ w wiadomo¶ci news:_pXJa.16129$Jw6.6888829_at_news1.news.adelphia.net...
> For the number of days in a month, one way is
>
> SELECT To_Date( '0601' || To_Char( SYSDATE, 'yyyy' ), 'mmddyyyy' ) -
> To_Date( '0501' || To_Char( SYSDATE, 'yyyy' ), 'mmddyyyy' )
> FROM dual;
>
> for finding all prices in affect for May of this year you could
>
> select *
> from table
> where to_char( start_date, 'yyyy' ) = to_char( sysdate, 'yyyy' )
> and to_char( end_date, 'yyyy' ) = to_char( sysdate, 'yyyy' )
> and '05' between to_char( start_date, 'mm' ) and to_char( end_date,
'mm' );
>
>
> "Macius The Great" <Maciej.Krych(usun to )_at_telekomunikacja.pl> wrote in
> message news:bd9bo0$2jk$1_at_nemesis.news.tpi.pl...
> > 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
> >
> >
> >
> >
>
>
Received on Tue Jun 24 2003 - 15:09:48 CEST