How to display only hours not minutes

[#1]

Hi

In a graph I want to display only the values per hour not by minute (as DATUMTIJD) has an inteval per minute

So how should this expression looks?

[Gysbert_Wassenaar · Accepted solution]

If DATUMTIJD is a timestamp you could use hour(DATUMTIJD) to get the hour of the timestamp. Or maybe you need to 'truncate' the minutes. In that case use floor(DATUMTIJD, 1/24) to round down or ceil(DATUMTIJD, 1/24) to round up.

[#3]

works fine thanks a lot!!!