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: [EMAIL PROTECTED] |[mailto:[EMAIL PROTECTED] |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 [EMAIL PROTECTED] so that your | message can get through to the mailing list cleanly | ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
