Between(Interval of two dates) in Postgres

From: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Between(Interval of two dates) in Postgres
Date: 2003-09-12 12:33:13
Message-ID: 70DD6153277512439CA4B66956A3098132D090@pdc.4tek-net.4tek.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2003-09-12 12:42:22 Re: Between(Interval of two dates) in Postgres
Previous Message Richard Huxton 2003-09-12 12:27:40 Re: Table OraclexPostgresql