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 abdallah_91@yahoo.com

Afternoon,

 

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

Outcomes