What datatype to make calculation?

[#1]

Goal:

Display the value in hours by calculating end - begin.

Problem

I have table with data

Begin	End
2011-11-10 12:12:12	2011-11-12 12:12:12
2011-11-10 12:12:12	2011-11-11 08:12:12

I need help with following issue:
*What datatype do I need to use in order calculate? I need a similiar datatype as datatime from SQL server. It doesn't work to use QlikView's datatype date to make a calculation

// JJ

[CELAMBARASAN]

Hi,

     Use TimeStamp for this type of data.

Celambarasan

[CELAMBARASAN · Accepted solution]

Hi,

     To get hour difference use Interval method

     Interval(End-Begin,'hh') which will give you the hour difference

Celambarasan