Morff wrote:
> 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 will only be true for certain calenders, not
for all.
Hence: use/check/set NLS parameters (in this case
territory) when playing with days-of-week, etc.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sat Nov 26 2005 - 07:13:27 CST
