Thread: compare month[modified]

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@yahoo.com

---

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

Hi,
SELECT users from userlog where lastlogindate > CURRENT_DATE-'1
month'::interval;
or
SELECT users from userlog where lastlogindate > CURRENT_DATE-'15
days'::interval;


I think this will work for you.

Have a nice day

Kaloyan Iliev


shakil tanvir wrote:

> 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@yahoo.com
>
> ------------------------------------------------------------------------
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls
> <http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
> to the US (and 30+ countries) for 2ў/min or less.

On Tue, 4 Apr 2006 00:05:49 -0700 (PDT)
shakil tanvir <tanvirshakil@yahoo.com> threw this fish to the penguins:

> 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

The "age" builtin function is handy in these circumstances:

  select users from userlog where age(lastlogindate) < '1 month';


> Can any one help with sql example?
>
> Shakil
> tanvirshakil@yahoo.com
>
>
> ---------------------------------
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.


--
"Are the gods not just?"  "Oh no, child.
What would become of us if they were?" (CSL)