I've got the following sql query:
SELECT DISTINCT(HOUR(track_time)) as track_hour, COUNT(*) AS track_hour_count FROM tbltrack
GROUP BY track_hour
It works correctly on windows nt but on a *nix based(redhat) machine it looks like it does a DISTINCT select of minuts.
The table is very standard with the track_time field set to:
type: TIME
default: 00:00:00
Thanks in advance
Regards,
Johan Hanekom
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
SELECT DISTINCT(HOUR(track_time)) as track_hour, COUNT(*) AS track_hour_count FROM tbltrack
GROUP BY track_hour
It works correctly on windows nt but on a *nix based(redhat) machine it looks like it does a DISTINCT select of minuts.
The table is very standard with the track_time field set to:
type: TIME
default: 00:00:00
Thanks in advance
Regards,
Johan Hanekom
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->