Re: How to select records based on time without sunday and saturday ?

"Morff" <morff1_at_wp.pl> wrote in message news:op.s0o26ysnq0kutt_at_nt_januszk...
> Dnia 23-11-2005 o 14:15:13 <anti00_at_poczta.onet.pl> napisał:
>
>> Hello
>> I want to select all record which contains date between monday and
>> friday, could YOu explain how to do that ?
>>
>> P.
>>
>
> piszesz sobie :
>
> select * from tabelka
> where to_char(data,'d') not in ('6','7')
>

which may need a function-based index for performance considerations

++ mcs Received on Wed Nov 23 2005 - 07:57:13 CST