On Tuesday, August 16, 2011 2:12:52 am Janiv Ratson wrote:
> Hi Adrain and thank you,
> Trac 0.12 uses microseconds as time value.
> What do you suggest?
extract(epoch ..) returns seconds which you are trying to compare to
microseconds. The solution would be to divide your 'time' values by 1,000,000
to
make them seconds. Like:
SELECT ticket, "time"/1000000, author, field, oldvalue, newvalue
FROM ticket_change
where "time"/1000000
BETWEEN
extract(epoch from (date 'now' - integer '30')) AND
extract(epoch from (date 'now'));
>
> Thanks,
> Janiv.
>
--
Adrian Klaver
[email protected]
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
