-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 31 July 2003 09:05, teknokrat wrote:
> The difference of two dates/timestamps always gives an interval. is
> there a way to convert this interval into number such as number of
> milliseconds or number of days?
>
Take a look at the User's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
If the number of seconds between timestamps is acceptable then this is the
solution I use:
SELECT ABS(EXTRACT(EPOCH FROM t.field1) - EXTRACT(EPOCH FROM t.field2)) AS
diff FROM table AS t;
Adjust to your column and WHERE needs. One caveat: this o
