Re: Converting a TimestampTz into a C# DateTime

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerome Wagner <jerome(dot)wagner(at)laposte(dot)net>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Converting a TimestampTz into a C# DateTime
Date: 2016-11-14 15:36:17
Message-ID: 30579.1479137777@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jerome Wagner <jerome(dot)wagner(at)laposte(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2016-11-14 15:38:37 Re: Converting a TimestampTz into a C# DateTime
Previous Message Jerome Wagner 2016-11-14 15:16:09 Re: Converting a TimestampTz into a C# DateTime