hhmm ROUND

robiverson · #1 (**permalink**) 12-26-08, 19:49

how can i round hhmm to nearest 30 minutes for ex 1140 round it to 1130 ,1210 to 1200 .

Please let me know .

ibm.ids · #2 (**permalink**) 12-26-08, 20:10

Stored procedure?

robiverson · #3 (**permalink**) 12-26-08, 21:55

i would like to use in the in the query.

ibm.ids · #4 (**permalink**) 12-27-08, 04:39

stored procedure?
select hhmmround(datetime_value) from ......

robiverson · #5 (**permalink**) 12-27-08, 08:55

I have tried it in the query
Routine (hhmmround) can not be resolved.

ibm.ids · #6 (**permalink**) 12-27-08, 08:58

You have to write your own hhmm_or_whatever_name procedure

fprose · #7 (**permalink**) 12-29-08, 08:59

Would need to be a function, not a stored procedure.

ibm.ids · #8 (**permalink**) 12-29-08, 14:37

You're right Fred - function.