Hi Jonas,

as HOUR_NOW() is already rounded to the hour (no minutes, seconds, milliseconds) the rounding in REMAP_TIMESTAMPS does not affect you here anyway.

However, in general, you can avoid the rounding by choosing a smaller time unit and divide the result by the corresponding factor.

Example:

gives you the number of days since 01.01.1970, as a decimal with HOURS precision.

Best

David

Hi David,

many thanks for your reply. I had the same idea, but urgently it does not work.

image1012440 51.2 KB .

.

Do you have any idea what else might be causing it?

Thanks and best regards,

Jonas

Hi Jonas,

okay, in this version, it is not required anymore to multiply with 1.0, as divisions always return a FLOAT.

Then the reason is that REMAP_TIMESTAMPS ignores times when you specify days that should be taken into account. So in this case, it only counts full days, so any number returned by REMAP_TIMESTAMPS is a multiple of 24.

In order to take times into account, you can add the time range 00:00-23:59 to at least one of the specified days.

Example:

This behavior is documented here under Day based calendar.

Cheers

David