Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to select records based on time without sunday and saturday ?
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')
-- Pozdrawiam Morff ---------------------- AQQ 141151Received on Wed Nov 23 2005 - 07:17:12 CST
![]() |
![]() |