Home > mailing lists

compare month[modified] - Mailing list pgsql-novice

From	shakil tanvir
Subject	compare month[modified]
Date	April 4, 2006 07:05:53
Msg-id	20060404070549.11204.qmail@web52407.mail.yahoo.com Whole thread Raw
Responses	Re: compare month[modified] (Kaloyan Iliev <news1@faith.digsys.bg>) Re: compare month[modified] (george young <gry@ll.mit.edu>)
List	pgsql-novice

Tree view

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.

pgsql-novice by date:

From: shakil tanvir
Date: 04 April 2006, 06:58:55
Subject: compare month

From: "A. Kretschmer"
Date: 04 April 2006, 07:09:16
Subject: Re: compare month

compare month[modified] - Mailing list pgsql-novice

Previous

Next