DB2 graphic  QMF Version 8

Formatting a time value

To specify a particular format for a time value, you use the FormatNum() function.

For example, to display the value of the column transaction_time in minutes, you might enter the following functional expression:

Value     =FormatNum(mm,transaction_time)

The format argument mm represents minutes when a row returns minutes data and represents months when a row returns months data.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004