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 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- -Achilleus ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
