compare month[modified]

From: shakil tanvir <tanvirshakil(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: compare month[modified]
Date: 2006-04-04 07:05:49
Message-ID: 20060404070549.11204.qmail@web52407.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all of you PostGreSQL fans,

I need to run a query like

SELECT users from userlog where lastlogindate is less than one month of current date
or
SELECT users from userlog where lastlogindate is less than 15 days of current date

Can any one help with sql example?

Shakil
tanvirshakil(at)yahoo(dot)com


---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2006-04-04 07:09:10 Re: compare month
Previous Message shakil tanvir 2006-04-04 06:58:50 compare month