Working with timestamp data type.
843859Jan 22 2007 — edited Feb 2 2007Hi all!,
I have some problems working with the timestamp data type.
Let's say that i have a table named order, where i store (in two timestamps) the date where the order was made, and the date where the order was executed.
I want:
1) first to find the difference between these to timestamps, let me call them a,b,
2) to find the average time of the difference of timestamps. With that i mean if my table has 60 typles for examples to get (b-a)/60.
Can these happen?
Thanks in advance,