On Tue, 10 Feb 2004, Michael Sterling wrote: > i'm trying to get the max time stamp, from each day, of a range of > dates, not just the max time stamp for the complete range dates but > for each day.
Maybe something like?
SELECT CAST(timestampcol AS DATE), max(timestampcol)
FROM thetable
GROUP BY CAST(timestampcol AS DATE);
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
