Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Converting a TimestampTz into a C# DateTime
Date
Msg-id 30579.1479137777@sss.pgh.pa.us
Whole thread Raw
In response to Re: Converting a TimestampTz into a C# DateTime  (Jerome Wagner <jerome.wagner@laposte.net>)
List pgsql-general
Tree view 
Jerome Wagner <jerome.wagner@laposte.net> writes:
> 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 ?

You can inspect the integer_datetimes setting, via SHOW or
current_setting().  In a libpq client it's also directly available
from PQparameterStatus().

            regards, tom lane

pgsql-general by date:

Previous
From: Jerome Wagner
Date:
Subject: Re: Converting a TimestampTz into a C# DateTime
Next
From: Albe Laurenz
Date:
Subject: Re: Converting a TimestampTz into a C# DateTime