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?
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
Thank you very much !!
Retrieving data ...