Timestamp

[07mishin]

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

[Taoufiq_Zarra]

@07mishin 

Floor it

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

[07mishin]

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