SQL Date

Posted 2022-04-22 8:19 by azri.

select date_format(time,'%Y-%m-%d %H:%i'), count(*)  from adsb_nopositions where time > '2022-04-21 15:00' group by date_format(time,'%Y-%m-%d %H:%i');