"Brian C. Doyle" <bdoyle@umpa-us.com> wrote: > > > Hello all, > > I am rather confident that this has been answered in the past but searching > for it has been a pain so I am asking for some assistance. > > I need a query to get data that is 6 months older than "today" or when that > query is run. > > So the where clause is something like > > WHERE table.date >= now() - 6 months > > I know that will not work so how should I do this? WHERE age(table.date) > '6 months' -- Jim Seymour | Spammers sue anti-spammers: jseymour@LinxNet.com | http://www.LinxNet.com/misc/spam/slapp.php http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund: | http://www.spamcon.org/legalfund/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
