Timestamp without seconds?

[qlikconsultant]

I need from a timestamp in a new atribute DD.MM.YYYY HH:MM.

For that i use:

date([mytimestamp])&' '&time(frac(floor([mytimestamp],1/1440)),'hh:mm') as timedatevalue

This skript works but if the time HH:MM:00 the he put the new value one minute before.

Example.: 16:50:00 ends as 16:49

Any idea how can i fix that or any sugestion how I can get DD.MM.YYYY HH:MM on an different way?

[swuehl · Accepted solution]

Try

timestamp#( timestamp( mytimestamp, 'DD.MM.YYYY hh:mm'), 'DD.MM.YYYY hh:mm') as timedatevalue

[#3]

Hi Markus,

maybe the the fraction 1/1440 is not as smooth as one would expext.

Please try Date#(Date(mytimestamp)&' '&Hour(mytimestamp)&':'& Minute(mytimestamp))

Hope it helps.

Grüße

Klaus

[#4]

swuehlwas faster and has the better code snippet.