Re: Specified date type but created column is timestamp without time zone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Elston <mike(dot)elston(at)gmail(dot)com>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Specified date type but created column is timestamp without time zone
Date: 2021-11-06 19:31:18
Message-ID: 593392.1636227078@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Mike Elston <mike(dot)elston(at)gmail(dot)com> writes:
> I created a table containing a column of type "date" but the
> describe command reports that the created column is "timestamp without time
> zone". Why isn't it simply "date"?

> psql (EnterpriseDB) 13.4.8

If you're using EDB, their server is hacked in a lot of ways to act
more like Oracle, and I think this discrepancy is one of them.
Oracle's idea of "date" corresponds more or less to our "timestamp",
so they translate.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jonas Gassenmeyer 2021-11-08 08:20:33 Check explain plan of a running query in other session
Previous Message Mike Elston 2021-11-06 19:11:32 Specified date type but created column is timestamp without time zone