From: | Kevin Heflin <kheflin(at)shreve(dot)net> |
---|---|
To: | "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | looking for suggestions |
Date: | 1999-08-24 02:10:10 |
Message-ID: | Pine.LNX.4.10.9908232103450.15190-100000@mercury.shreve.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've got a single table which lists usernames, addressinfo and signup
dates
signup date is data type 'date'
I'm wondering if it's possible through the magic of SQL to run a query
like:
select * from table where signupdate > '01/01/1999' and < '04/01/1999';
then in the results, I would like to break this down by months. So I can
show total signups for january 1999, then February 1999 etc..
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612
kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Hub.Org News Admin | 1999-08-24 02:35:40 | |
Previous Message | Jablonski, David | 1999-08-23 22:02:27 | RE: [GENERAL] Remote PSQL... |