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

Home -> Community -> Usenet -> c.d.o.misc -> days old sql query

days old sql query

From: David Arden Stevensonn <dfgkkdfjgddfgd_at_gmail.com>
Date: Sun, 24 Apr 2005 16:22:13 GMT
Message-ID: <VIPae.11220$n93.1616@twister.nyc.rr.com> 







One of the columns in my table holds the SYSDATE of when a record was
inserted. How can I get the age in days (since it was inserted)  using a sql
query? Just want an integer of the num of days.



Thanks in advance.
Received on Sun Apr 24 2005 - 11:22:13 CDT












Original text of this message













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