Calculating time difference

Technical queries
, , , ,
#1

Hello Helical,

How to calculate the difference between two Date Time columns in Derby Database? Using Helical Insight 4.1 GA Enterprise edition

Thanks,
Sesa.

#2

Hello Sesa,

The below mentioned steps can be used in other db also. Otherwise a custom column can also be used.

  1. Open the report in edit mode.

image

  1. Right-click on the column

image

  1. Select the Date Time *Datatype and again then select the related function as DATEDIFF.

image

Final result.
image

Thanks,
Helical Insight.