I want to find the difference of time in terms of minutes. My requirement has two fields with a length of 6.0. How would I go about this?
There's no DB2 function to do this directly. You'd have to combine a couple of functions something like:
HOUR(ENDING -STARTING )*60 + MINUTE(ENDING -STARTING )

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Database issues resolved


This was first published in February 2004