Re: bigint and unix time

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
adrian(dot)klaver(at)gmail(dot)com