Received: from symcom.com ([209.11.41.82]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MCJbx36310 for ; Thu, 22 Feb 2001 07:19:37 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200102221219.f1MCJbx36310@mail.postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Thu, 22 Feb 2001 07:26:17 -0500 Date: Thu, 22 Feb 2001 07:26:17 -0500 From: "postgresql" To: "PgSQL-SQL" Subject: problem with dates X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200102/336 X-Sequence-Number: 1532 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. if there is some document somewhere that explains this just point me to it. Thanks again. Ted