Received: from smtp018.mail.yahoo.com (smtp018.mail.yahoo.com [216.136.174.115]) by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2Q8Gqw63382 for ; Mon, 26 Mar 2001 03:16:52 -0500 (EST) (envelope-from waheed_rahuman@yahoo.com) Received: from unknown (HELO techaxis) (213.42.51.56) by smtp.mail.vip.sc5.yahoo.com with SMTP; 26 Mar 2001 08:16:49 -0000 X-Apparently-From: Message-ID: <00e001c0b5ce$21de96a0$660101c8@emirates.net.ae> Reply-To: "waheed_rahuman" From: "waheed_rahuman" To: References: <20010325065031.26528.qmail@web1001.mail.yahoo.com> Subject: SQL Date help Date: Mon, 26 Mar 2001 12:24:07 +0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200103/513 X-Sequence-Number: 2184 Hi, I am a newbie to SQL and postgresql too. please guide me in the following... 1.How i can create date while i am inserting into the table ,in which the field is date data type.(date should not be a current date and its should be created as in java date(int,int,int) 2. How i can compare the date field. For example , how i can get the all the records between to two dates please help in this regards i thank you regards waheed _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com