Timestamp Format problem

[alexandermllr]

Hello,

I have a problem wih the timestamp format, this is my script:

if(Start_time = 'leer',Previous(Start_time )-Time(1/1440,'mm'),(Start_time )) as Start_time,

I always get the previous time - 1 min not in a timestamp format.

How can I get always a timestamp?

Thank you!

[prieper · Accepted solution]

TIMESTAMP is just a formatting. Calculation itself is done on pure numbers.

Suggest to use

TIMESTAMP(if(Start_time = 'leer',Previous(Start_time )-(1/1440),(Start_time ))) as Start_time

instead.

Peter

[alexandermllr]

Thank you very much !!