Re: [CHALLANGE] Add seconds to a date
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 26 Feb 2002 12:44:42 -0000
Message-ID: <3c7b834f$0$8510$ed9e5944_at_reading.news.pipex.net>
Date: Tue, 26 Feb 2002 12:44:42 -0000
Message-ID: <3c7b834f$0$8510$ed9e5944_at_reading.news.pipex.net>
"panjas51" <panjas51_at_yahoo.fr> wrote in message
news:3c1b889f.0202260131.137e678b_at_posting.google.com...
> I don't know way you divide by (24*60*60), but anyway it seems
> working.
24 hours in a day, 60 minutes in an hour, 60 seconds in a minute. You could just divide by 86400 which is the number of seconds in a day but I don't think it reads as well.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Tue Feb 26 2002 - 13:44:42 CET