AnsweredAssumed Answered

max(date) or last hour of that day

Question asked by WDziuba on Feb 10, 2017
Latest reply on Feb 10, 2017 by



I have a rest end point that contains 24 hour entries for each day regarding precipitation. But I only need to extract the last hour of that day, or the max(date) value. For example:


2005-01-14 01:00:00
2005-01-14 04:00:00
2005-01-14 05:00:00
2005-01-14 08:00:00

2005-01-14 23:00:00


So in the example above, I only need to extract the last value. 


How does one query the rest end point to extract only that value?


Any help would be appreciated.....Walter