From: | Kaloyan Iliev <news1(at)faith(dot)digsys(dot)bg> |
---|---|
To: | shakil tanvir <tanvirshakil(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: compare month[modified] |
Date: | 2006-04-04 07:15:18 |
Message-ID: | 44321D06.9030006@faith.digsys.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)yahoo(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | inner | 2006-04-04 09:55:21 | BYTEA: insert query max size |
Previous Message | Kaloyan Iliev | 2006-04-04 07:13:12 | Re: compare month |