SELECT timestamp('2001-06-12'::date - '2000-06-12'::date)

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT timestamp('2001-06-12'::date - '2000-06-12'::date)
Date: 2001-05-12 19:26:45
Message-ID: 3AFD8E75.A1E5115B@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

The "+" operator is not defined for (date, date) which seems very
logical to me since adding dates does in my opinion not make sense.
performance=# SELECT timestamp('2001-06-12'::date + '2000-06-12'::date);

ERROR: Unable to identify an operator '+' for types 'date' and 'date'
You will have to retype this query using an explicit cast

Surprisingly "-" is defined for (date, date).
performance=# SELECT timestamp('2001-06-12'::date - '2000-06-12'::date);

timestamp
------------------------
1970-01-01 01:06:05+01
(1 row)

Does anybody understand the logic behind that operation and why is the
result not something like 1970-01-01 00:00:00?

Hans

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message The Hermit Hacker 2001-05-12 22:47:24 Re: multi-table join, final table is outer join count ...
Previous Message Michael Richards 2001-05-12 18:57:56 Constraints...