Re: Support for DATETIMEOFFSET

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Support for DATETIMEOFFSET
Дата
Msg-id 30253.1586527629@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Support for DATETIMEOFFSET  (Jeremy Morton <admin@game-point.net>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Fast DSM segments
Следующее
От: James Coleman
Дата:
Сообщение: Re: [PATCH] Incremental sort (was: PoC: Partial sort)