Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
problems calling it once per second. Count the maximum and minimum number of online objects in a minute. select '2017-07-05 11:11:00', min(cnt), max(cnt) from result where crt_time between '2017-07-05 11:11:00' and '2017-07-05 11:12:00'; or select to_char(crt_time, 'yyyy-mm-dd hh24:mi:00'),