Q

In search of a DB2 time function

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

Dig deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close