Re: [cx-oracle-users] calculate time differences on timestamp column

[Walter D. <wa...@li...>]

On 06.07.11 15:49, Anthony Tuininga wrote:

> Hi,
> 
> You can simply subtract them. cx_Oracle will return a datetime
> instance for the timestamp column and you can simply do
> 
> timestampB - timestampA
> 
> which will return to you a timedelta instance. You can also subtract
> them in Oracle and return the result to Python if you prefer that
> option.

Or you could use the LAG() or LEAD() analytic functions.

Servus,
   Walter