Re: date functions

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 Received on Tue Jun 24 2003 - 13:32:40 CEST