Skip to Content
Former Member
Sep 13, 2011 at 08:30 PM

Notification Table QFIH - BD duration format is 1.5351340900000000E+08


I'm attempting to create a query utilizing downtime. The field in question is AUSZT.

However, the breakdown duration output takes the following format: 1.5351340900000000E+08

This is causing some difficulty when it comes to presenting the data and also, the bigger issue arises when it comes to calculating this output.

Instead of 1.5351340900000000E+08, this should be 1.54

Looking for some help on how to extract this data so it looks "normal" using SQ01. Any advice?

Edited by: PMPSMM on Sep 13, 2011 3:32 PM