topic Timestamp in App Development

Timestamp

07mishin — Tue, 22 Feb 2022 07:07:37 GMT

Good day.
I have some "date" in format "2021-06-18T17:05:29.636+03:00"
I need max date, but when I used function, I have 2 instead 1 rows of 8.

First:
Date(Timestamp(Timestamp#(entityJson.publishDate),'YYYY-MM-DDhh:mm:ss.sss±hh:mm'),'DD.MM.YYYY hh:mm:ss') as "Date"

Second:
max("Date") as max_date

As a result, 2 rows remain:

max_date

44391.629151725

44391.632984977

##timestam

Re: Timestamp

Taoufiq_Zarra — Tue, 22 Feb 2022 09:23:09 GMT

@07mishin

Floor it

max(floor(Date)) instead of max(Date)

Re: Timestamp

07mishin — Tue, 22 Feb 2022 14:48:38 GMT

Thanks, but "floor" rounds down.
And will not always considered be the correct value the maximum.