Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MEYNx48585 for ; Thu, 22 Feb 2001 09:34:23 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id OAA28253; Thu, 22 Feb 2001 14:35:15 GMT Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 9CE1D2A3AD; Thu, 22 Feb 2001 14:29:41 +0000 (GMT) Message-ID: <008c01c09cdb$e4594380$1001a8c0@archonet.com> From: "Richard Huxton" To: "postgresql" , "PgSQL-SQL" References: <200102221219.f1MCJbx36310@mail.postgresql.org> Subject: Re: problem with dates Date: Thu, 22 Feb 2001 14:29:35 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/338 X-Sequence-Number: 1534 From: "postgresql" > This is a rather generic question about "date" and "time". I seem to > be beating my head on the wall. I was trying to use a set up a table > with a 'date' and 'time' field. I wanted to keep the two separate. > > Can someone explain if there is a difference between a time field > and a timestamp. I don't mean the visual date and time as a single > element. I mean in concept. I have been pouring through the docs > and it appears from my reading that a 'date' field is supposed to act > like the date portion of a timestamp. But it doesn't and I just don't > understand why. What isn't working correctly? I seem to be able to compare dates with timestamps and combine a date + time into a timestamp. > if there is some document somewhere that explains this just point > me to it. Look at the page "datetime-types.htm" in the docs (might only be in the docs for 7.1). - Richard Huxton