Re: Support for DATETIMEOFFSET - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Support for DATETIMEOFFSET
Date
Msg-id 30253.1586527629@sss.pgh.pa.us
Whole thread Raw
In response to Re: Support for DATETIMEOFFSET  (Jeremy Morton <admin@game-point.net>)
List pgsql-hackers
Jeremy Morton <admin@game-point.net> writes:
> 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,

Really?  That would be a remarkable feat for a mere datatype to
accomplish.

> and for that reason alone it makes it 
> invaluable in my opinion.  It should be used universally instead of 
> datetime.

What's it do that timestamptz together with setting timezone to UTC
doesn't?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Fast DSM segments
Next
From: James Coleman
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)