Re: datediff()
From: 170 Systems <170sys_at_netcom.com>
Date: Thu, 1 Dec 1994 15:13:01 GMT
Message-ID: <170sysD050xp.J75_at_netcom.com>
Date: Thu, 1 Dec 1994 15:13:01 GMT
Message-ID: <170sysD050xp.J75_at_netcom.com>
: In Sybase I'd say:
: select datediff(minutes, date1, date2) from table where ...
In Oracle you'd say:
select round((date2 - date1) * 24 * 60) from table where ...
to get minutes (rounded to the nearest minute). Date subtraction returns the difference, in days, between two dates. Incidentally, I don't believe Oracle dates stores milliseconds.
Dan Kennedy
170 Systems, Inc.
Received on Thu Dec 01 1994 - 16:13:01 CET