Re: Between(Interval of two dates) in Postgres

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Amin Schoeib <aschoeib(at)4tek(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Between(Interval of two dates) in Postgres
Date: 2003-09-12 12:42:22
Message-ID: Pine.LNX.4.44.0309121442010.3181-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2003-09-12 13:29:39 difference when using 'distinct on'
Previous Message Amin Schoeib 2003-09-12 12:33:13 Between(Interval of two dates) in Postgres