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