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 > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster