SELECT Date

From: Andy Lewis <alewis(at)mpsi(dot)net>
To: PostgreSQL mailinglist <pgsql-general(at)postgreSQL(dot)org>
Subject: SELECT Date
Date: 1998-10-08 18:45:34
Message-ID: Pine.LNX.3.96.981008134044.17340A-100000@shell.mpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with somedate defined as date.

I want to select all rows that are from todays date back to 7 days
ago. Or in this case 10-1-1998.

data in the somedate fields appear as: 10-7-1998

Can someone help?

Thanks in advance

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anand Surelia 1998-10-08 19:07:59 Re: [GENERAL] Row Nums
Previous Message Terry Mackintosh 1998-10-08 18:06:00 Re: [ADMIN] RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml'