Re: Correction of how to use TimeZone by ControlFile(xlog.c)

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Дата
Msg-id 87wswcld4i.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches
"Andrew Dunstan" <andrew@dunslane.net> writes:

> That's probably the worst of all possible options. Two very common uses of
> CSVlogs will be a) to load them into a PostgreSQL table and b) to load them into
> a spreadsheet such as Excel. In both cases having a Unix epoch time rather than
> a timestamp is likely to be very annoying.

Strangely those are precisely the use cases I was thinking of as well. For
both of those cases you need a timestamp which is unambiguous and understood
everywhere. Any text representation is going to depend on other tools using
the a compatible parser. Integers can be parsed by anything.

But perhaps I overestimate Excel's abilities.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


В списке pgsql-patches по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Следующее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: Correction of how to use TimeZone by ControlFile(xlog.c)