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

[<prz...@po...>]

On Wed, Jul 06, 2011 at 08:38:24AM -0400, Gerrat Rickert wrote:
> > -----Original Message-----
> > From: prz...@po... [mailto:prz...@po...]
> > Sent: July 6, 2011 8:22 AM
> > To: cx-...@li...
> > Subject: [cx-oracle-users] calculate time differences on timestamp
> > column
> 
> [snip]
>  
> > What I'd like to achive is to get delta time between 'A' and 'B' (=
> > time of code 'B')
> > but for all 'A' and 'B' (as an output I get rows of numbers).
> > How can I calculate this using cx-oracle ?
> > 
> > 
> > Regards
> > Przemyslaw Bak (przemol)
> 
> Your question is a straight SQL question, and has nothing to do with
> cx_Oracle.
> There is a great website, www.stackoverflow.com that this question is
> perfect
> for.  You might get better results if you asked it there.
> 
> ...your question might have even been asked & answered there already:
> http://stackoverflow.com/questions/4308620/difference-in-time-between-re
> cords

I thought that to get the result I need to have two cursors going through the data
and substract between them.
Indeed - my SQL knowledge it very small ... ;-) 

Regards
Przemyslaw Bak (przemol)



















































----------------------------------------------------------
Kredyt gotowkowy nr 1! Teraz do 150 000zl bez zaswiadczen!
http://linkint.pl/f29e1