Re: ** HELP WITH DATE FUNCTIONS **
Date: 19 Sep 1994 12:21:09 +0100
Message-ID: <35js75$2i8_at_crocus.csv.warwick.ac.uk>
ram_at_artecon.com (Ram Rao) writes:
> Hi world
> When I do a
> SELECT to_date('16-SEP-94 14:12:18','DD-MON-YY HH24:MI:SS') -
> TO_DATE('12-SEP-94 00:01:32', 'DD-MON-YY HH24:MI:SS')
> FROM DUAL
> I get the answer as 4.59081019
> Now I am confused as to what this 4.59081019 is!
It's the number of days; 4.59081019 --> 4 days, 14 hours, 10 mins, 46 seconds, which is correct and precisely what you asked for. Oracle stores dates as Julian days, wherein the sub-decimal part is the time.
> I would appreciate if you can email me at ram_at_artecon.com
Ok; copy sent there as well.
> thanx
> --ram
> ps
> if this is a RTFM situation, I would appreciate the page numbers
> please :)
Sorry; don't know where this is documented, off the top of my head; I guess somewhere in the front of the SQL Language Reference Manual.
> ORACLE 7 on a Sun SPARC 1000 running SunOS 5.3, PL/SQL ver
> 2.0.17.1.0
Hank Robinson
Oracle DBA
University of Warwick
Received on Mon Sep 19 1994 - 13:21:09 CEST