Re: [SQL] max timestamp

[Tomasz Myrta]

Dnia 2004-02-10 19:14, Użytkownik Michael Sterling napisał:

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.
select max(some_time)
group by some_time::date
or

select max(some_time)
group by date_trunc('day',some_time)
Regards,
Tomasz Myrta
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]