[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 info

[SQL] need date clarification

how can i extract the system date in postgress. Thanks & Regards Palanivel P.K 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 unauthori

Re: [SQL] Need clarification

Sorry, I didn't get ur point...please, tell me exact query to extract the rows from a table A which contains a date field named DTE whose difference is 30 days as compared to the current date... Thanks & Regards Palanivel P.K