Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thank you very much !!