Rounding minutes of DATE type in PL/SQL

From: Povodi Ohre a.s. <OHRE_at_UNL.PVTNET.CZ>
Date: Fri, 12 Feb 1999 12:23:04 +0100
Message-ID: <7a13a7$a87$1@cbu.pvtnet.cz>

Dear Friends,

              does anybody know how
to round DATE type to 10th of minutes
in PL/SQL?

Examples: 12:25:30 -> 12:30:00
                   14:04:59 -> 14:00:00
                   23:59:00 -> 00:00:00 of next day

etc.

Command ROUND(SYSDATE, 'MI') rounds
only to minutes not to 10th of minutes.

Please send me a short message to rnature1_at_hotmail.com

Thank you in advance

                      Robert

Received on Fri Feb 12 1999 - 05:23:04 CST