Re: date functions

U¿ytkownik "Guido Konsolke" <guido.konsolke_at_triaton.com> napisa³ w wiadomo¶ci news:1056453462.624678_at_news.thyssen.com...
> Macius The Great schrieb in Nachricht ...
> >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
>
> Hi MK,
>
> to get the prices:
> select price
> from <tablename>
> where to_char(effective_start_date,'MM') = '05'
> or to_char(effective_end_date,'MM') = '05';
>
> Notes: not very efficient, won't use indexes
> if they aren't function based.
>
> But this is only meant to give you an idea.
>
> hth,
> Guido
>

[Quoted] thanx Guido but in fact price can start loong before may and end looong after may it menas that it is affective in may but we cant find it when we lookig for ' 05' Received on Tue Jun 24 2003 - 13:44:01 CEST