Re: max timestamp - Mailing list pgsql-sql

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 thetableGROUP BY CAST(timestampcol AS DATE);