-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
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?
Also does anyone know what field type an interval would map to in jdbc?
thanks
---(end of broadcast)
