Re: rounding to a quater of an hour (hh:15, hh:30,hh:45,hh:00)

On Wed, 23 Oct 2002 16:12:29 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>any idea how? (besides writing a function)
>
>Thanx.
>.......
>We use Oracle 8.1.7.3 on Solaris 2.7 boxes
>remove NSPAM to email

trunc(sysdate)
+to_number(to_char(sysdate,'HH24'))/24
+(mod(to_number(to_char(sysdate,'MI'

                             ),15
           )*15)/3600

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 23 2002 - 12:08:54 CDT