Re: Support for DATETIMEOFFSET

Oh well.  Guess I keep using SQL Server then.  datetimeoffset makes it 
impossible for developers to make the mistake of forgetting to use UTC 
instead of local datetime, and for that reason alone it makes it 
invaluable in my opinion.  It should be used universally instead of 
datetime.

-- 
Best regards,
Jeremy Morton (Jez)

Andreas Karlsson wrote:
> 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
> 
> 
>