Postgres Pro
Downloads
Home   >   mailing lists

SELECT Date - Mailing list pgsql-general

From Andy Lewis
Subject SELECT Date
Date
Msg-id Pine.LNX.3.96.981008134044.17340A-100000@shell.mpsi.net
Whole thread Raw
In response to to my last letter about embedded SQL  (Memphisto <szoli@valerie.inf.elte.hu>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Don't remember how to update a table :-(
Next
From: Anand Surelia
Date:
Subject: Re: [GENERAL] Row Nums