Re: compare month[modified]

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.