Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Compute difference between timestamps

Re: Compute difference between timestamps

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 03 Jun 2006 18:14:38 GMT
Message-ID: <Xns97D7727C619A3ianalvistahotmailcom@70.169.32.36> 





c8s3dw_at_verizon.net wrote in news:1149358010.949333.80590
@i40g2000cwc.googlegroups.com:



> In Oracle database, given two timestamp columns, how do I compute the

> difference, expressed in seconds, to three decimal places? i.e. 452.936

> 

> 




By using builtin functions & basic arithmetic.
Received on Sat Jun 03 2006 - 13:14:38 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US