X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id AF66BD1DC01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 15 Feb 2004 19:58:41 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 71619-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 15 Feb 2004 15:58:40 -0400 (AST)
Received: from serwer.skawsoft.com.pl (skawina.eu.org [80.48.213.66])
	by svr1.postgresql.org (Postfix) with ESMTP id DD662D1DD2C
	for <pgsql-sql@postgresql.org>; Sun, 15 Feb 2004 15:58:38 -0400 (AST)
Received: from klaster.net (backbone.zab.citynet.pl [212.244.6.69])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 48D942B3CB; Sun, 15 Feb 2004 20:58:32 +0100 (CET)
Message-ID: <402FD021.8020403@klaster.net>
Date: Sun, 15 Feb 2004 21:01:37 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
 rv:1.6) Gecko/20040113
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Michael Sterling <stermic@gw.co.jackson.mo.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: max timestamp
References: <f7359f44.0402101014.77198f7b@posting.google.com>
In-Reply-To: <f7359f44.0402101014.77198f7b@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/183
X-Sequence-Number: 16873

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