Need clarification - Mailing list pgsql-sql

From palanivel.kumaran@scandent.com
Subject Need clarification
Date
Msg-id OFB8FB5793.485B1314-ON6525700A.003616B6@scandentgroup.com
Whole thread Raw
Responses Re: Need clarification  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql



how can retrieve rows where the datedifference is more than 30...
assume there exists a field named 'datacreated' which is of type 'date'. I
need to compare it with the current date and need to extract the matched
rows....

thanks in advance.

Palanivel

Important Email Information :- The  information  in  this  email is
confidential and may  be  legally  privileged. It  is  intended  solely for
the addressee. Access to  this email  by anyone  else  is  unauthorized.  If
you are not the intended recipient, any disclosure, copying, distribution or
any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. If you are not the intended addressee please contact
the sender and dispose of this e-mail immediately.



pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: Calling Functions in RULEs
Next
From: Achilleus Mantzios
Date:
Subject: Re: Need clarification