Re: Using date format
"Tony Andrews" <[email protected]> Mon, 24 Feb 2003 14:34:39
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-886647-2003.02.24-14.18.34--gcdod-oracle#[email protected]> |
(TIME1 - TIME2)*86400 will always be positive provided that TIME1 is later than TIME2. If it is negative, it means your process ended before it began! 18-01-2003 00:00:00 is midnight at the START of 18-01-2003, i.e. 1 second later than 17-01-2003 23:59:59, so a process that started at 18-01-2003 23:55:47 cannot possible finish at 18-01-2003 00:00:00 which is 86147 seconds earlier, though it may well end at 19-01:2003 00:00:00, i.e. 253 seconds later. --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].