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
O [EMAIL PROTECTED] έγραψε στις May 23, 2005 :
>
>
>
>
> how can retrieve rows where the datedifference is more than 30...
more than 30 in what units?
years,days,milliseconds??
> assume there exists a field named 'datacreated' which is of type 'date'. I
> need to compare it with the current
: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 a
tgresql.org
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: [SQL] Need
clarif
am 23.05.2005, um 16:31:55 +0530 mailte [EMAIL PROTECTED] folgendes:
>
>
>
>
> 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...
test=# create