Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to select records based on time without sunday and saturday ?

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

From: Morff <morff1_at_wp.pl>
Date: Wed, 23 Nov 2005 14:17:12 +0100
Message-ID: <op.s0o26ysnq0kutt@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')

-- 
Pozdrawiam
Morff
----------------------
AQQ 141151
Received on Wed Nov 23 2005 - 07:17:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US