Re: Number of days -function

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 11 Oct 2001 00:37:54 -0700
Message-ID: <a20d28ee.0110102337.4b53e866@posting.google.com>

sweidanz_at_yahoo.com wrote in message news:<UE4x7.7$yb1.698_at_nsw.nnrp.telstra.net>...
> Folks,
> Is there a way (function or an equation) to retunr number of days between
> two dates?
>
> thanks,
> ZS

As the unit of a date column is a day, there is no need for that. Just subtract them.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 11 2001 - 02:37:54 CDT

This message: [ Message body ]
Next message: Gert Van Gaever: "[iAS Email Server] Can't login with existing user in Thin Client"
Previous message: Francesco Dini: "Re: Help with Tablespace fragmentation"
In reply to: sweidanz_at_yahoo.com: "Number of days -function"
Next in thread: Valentin Minzatu: "Re: Number of days -function"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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