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