Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4D345A89399 for ; Sat, 12 May 2001 23:04:05 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4D33vR22463; Sat, 12 May 2001 23:03:57 -0400 (EDT) To: =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= cc: pgsql-sql@postgresql.org Subject: Re: SELECT timestamp('2001-06-12'::date - '2000-06-12'::date) In-reply-to: <3AFD8E75.A1E5115B@cybertec.at> References: <3AFD8E75.A1E5115B@cybertec.at> Comments: In-reply-to =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= message dated "Sat, 12 May 2001 21:26:45 +0200" Date: Sat, 12 May 2001 23:03:56 -0400 Message-ID: <22460.989723036@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/115 X-Sequence-Number: 2931 =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= writes: > Surprisingly "-" is defined for (date, date). What's surprising about that? It yields an integer number of days between the dates: regression=# select '2001-06-12'::date - '2000-06-12'::date; ?column? ---------- 365 (1 row) > performance=# SELECT timestamp('2001-06-12'::date - '2000-06-12'::date); > timestamp > ------------------------ > 1970-01-01 01:06:05+01 > (1 row) timestamp(integer) converts a Unix timestamp value (seconds since 1970) into a timestamp. regards, tom lane