compare month

From: shakil tanvir <tanvirshakil(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: compare month
Date: 2006-04-04 06:58:50
Message-ID: 20060404065850.9814.qmail@web52412.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
or
SELECT users from userlog where lastlogindate is less than 15 days

Can any one help with sql example?

Shakil
tanvirshakil(at)yahoo(dot)com


---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message shakil tanvir 2006-04-04 07:05:49 compare month[modified]
Previous Message george young 2006-04-03 17:38:10 Re: Two configuration issues...