Re: Need clarification

O palanivel(dot)kumaran(at)scandent(dot)com έγραψε στις 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 date and need to extract the matched
> rows....
>

select * from footable where datacreated = now()::date;

> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
-Achilleus