From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: palanivel.kumaran@scandent.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Need clarification
Date: Mon, 23 May 2005 13:17:15 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0505231315110.8736-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <OFB8FB5793.485B1314-ON6525700A.003616B6@scandentgroup.com>
O palanivel.kumaran@scandent.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
-Achilleus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, palanivel.kumaran@scandent.com
Subject: Re: Need clarification
In-Reply-To: <Pine.LNX.4.44.0505231315110.8736-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox