Re: ** HELP WITH DATE FUNCTIONS **
Date: Mon, 19 Sep 1994 08:37:37 +0000
Message-ID: <CwDByp.F0H_at_cisa.bt.co.uk>
Ram Rao (ram_at_artecon.com) wrote:
: 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!
: I would appreciate if you can email me at ram_at_artecon.com
: thanx
: --ram
: ps
: if this is a RTFM situation, I would appreciate the page numbers please :)
: ORACLE 7 on a Sun SPARC 1000 running SunOS 5.3, PL/SQL ver 2.0.17.1.0
Date arithmetic is cast to number of days (section 2-28 SQL Lang ref man), so 4.59 is the difference in days between your date operands.
Steve Laverack
BT,
UK.
Received on Mon Sep 19 1994 - 10:37:37 CEST