From: | "P(dot)MO" <04mic4ht65k1nv3(at)jetable(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | select with date_part and month failure.... |
Date: | 2006-04-18 07:20:50 |
Message-ID: | 6.2.3.4.2.20060418091102.02943380@pop.libertysurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
I have the same problem against various PostgreSQL 8.1.3, 8.0.2 and 7.4.7:
I have a table containing periodical invoices. it contain's the last time the
invoce was printed and a period in month to be waited before next time.
My querry works with date_parts on days but never with months:
create temp table tstdates (
lasttimedone date,
period integer
);
insert into tstdates values ('2006-01-01',2);
insert into tstdates values ('2006-02-01',2);
insert into tstdates values ('2006-03-01',2);
insert into tstdates values ('2006-04-01',2);
-- doesn' t works :
select * from tstdates where
date_part('month',now()-lasttimedone) >= period;
-- works :
select * from tstdates where
date_part('days',now()-lasttimedone) >= period*30;
Can someone point me an error ?
T.I.A. PM.
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2006-04-18 08:07:11 | Re: select with date_part and month failure.... |
Previous Message | Hannes Dorbath | 2006-04-18 07:09:01 | Re: tsearch partial word |