Re: Support for DATETIMEOFFSET

On 4/10/20 10:34 AM, Jeremy Morton wrote:
> I've noticed that Postgres doesn't have support for DATETIMEOFFSET (or
> any functional equivalent data type) yet.  Is this on the roadmap to
> implement?  I find it a very useful data type that I use all over the
> place in TSQL databases.

Hi,

I do not think anyone is working on such a type. And personally I think
such a type is better suite for an extension rather than for core
PostgreSQL. For most applications the timestamptz and date types are
enough to solve everything time related (with some use of the timestamp
type when doing calculations), but there are niche applications where
other temporal types can be very useful, but I personally do not think
those are common enough for inclusion in core PostgreSQL.

I suggest writing an extension with this type and see if there is any
interest in it.

Andreas