Re: Converting a TimestampTz into a C# DateTime

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Converting a TimestampTz into a C# DateTime
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B5397CD01@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: Converting a TimestampTz into a C# DateTime  (Jerome Wagner <jerome.wagner@laposte.net>)
Список pgsql-general
Jerome Wagner wrote:
> seeing you answer I have a question for which I found no answer a few weeks ago : is there a way to
> know at runtime which internal representation timestamps have ?
> I am trying to deal with the COPY binary protocol with only SQL access to the remote server and would
> like to find a way to know the internal representation to read / write the correct timestamps.

I guess you have to use the SPI interface to run the SQL statement

   SHOW integer_datetimes;

and check if the result is 'on'.

Yours,
Laurenz Albe

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Converting a TimestampTz into a C# DateTime
Следующее
От: Arjen Nienhuis
Дата:
Сообщение: Re: Converting a TimestampTz into a C# DateTime