timestamp

[agni_gold]

timestamp handeling in Qlikview

[SunilChauhan]

use time function inplace

temp:

LOAD

     Timestamp(CBATIME) as cba

FROM

(qvd);

temp2:

load

cba

Resident temp where Time(cba, 'HH:MM:SS TT')='12:00:00 AM';

hope this helps

[its_anandrjs]

Hi,

Try like

temp:

LOAD

     Timestamp(CBATIME,'HH:MM:SS TT' ) as cba

FROM

(qvd);

temp2:

load

cba

Resident temp where cba ='12:00:00 AM';

Hope this helps

Thanks & Regards

[MarcoWedel]

Qlikview 10 SR4 Reference Manual

pages 447ff

regards

Marco