Обсуждение: Between(Interval of two dates) in Postgres

Hi,
can somebody tell me
How I can use the Oracle between function in Postgres?
Like this:
Select name from test
Where date_f between '31.01.2000'
And '31.01.2003'

Thanxx

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel.  +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

Hello

set DateStyle TO German ;
SET
testdb011=> select current_date between '31.01.2000' and '31.01.2004';
 ?column?
----------
 t

regards
Pavel



On Fri, 12 Sep 2003, Amin Schoeib wrote:

>
> Hi,
> can somebody tell me
> How I can use the Oracle between function in Postgres?
> Like this:
> Select name from test
> Where date_f between '31.01.2000'
> And '31.01.2003'
>
> Thanxx
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel.  +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>
>