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
tgresql.org
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: [SQL] Need
clarif
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@p
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
