Re: Converting a TimestampTz into a C# DateTime - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Converting a TimestampTz into a C# DateTime
Date
Msg-id A737B7A37273E048B164557ADEF4A58B5397CD01@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: Converting a TimestampTz into a C# DateTime  (Jerome Wagner <jerome.wagner@laposte.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Converting a TimestampTz into a C# DateTime
Next
From: Arjen Nienhuis
Date:
Subject: Re: Converting a TimestampTz into a C# DateTime