Re: Need clarification

Your're looking for the interval data type.

timestamp - timestamp 
or date - date   can be compared with interval
CURRENT_TIMESTAMP - '4d'::interval => today - 4 days

|-----Original Message-----
|From: palanivel.kumaran@scandent.com
|[mailto:palanivel.kumaran@scandent.com]
|Sent: Montag, 23. Mai 2005 11:52
|To: pgsql-sql@postgresql.org
|Subject: [SQL] Need clarification
|
|
|
|
|
|
|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.
|
|
|---------------------------(end of 
|broadcast)---------------------------
|TIP 3: if posting/reading through Usenet, please send an appropriate
|      subscribe-nomail command to majordomo@postgresql.org so that your
|      message can get through to the mailing list cleanly
|