Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Determining the DATE format with libpq - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Determining the DATE format with libpq
Date
Msg-id 16272.1503588417@sss.pgh.pa.us
Whole thread Raw
In response to [SQL] Determining the DATE format with libpq  (Sebastien FLAESCH <sf@4js.com>)
Responses Re: [SQL] Determining the DATE format with libpq  (Sebastien FLAESCH <sf@4js.com>)
List pgsql-sql
Tree view 
Sebastien FLAESCH <sf@4js.com> writes:
> Is there a way to know the current date format used in the SQL session?
> Ideally, we expect a libpq API.

Use PQparameterStatus().

> We cannot do a "SHOW DateStyle" each time we executing a SELECT!

You don't have to --- the server automatically reports changes in the
value of that parameter.
        regards, tom lane

pgsql-sql by date:

Previous
From: Sebastien FLAESCH
Date:
Subject: [SQL] Determining the DATE format with libpq
Next
From: Sebastien FLAESCH
Date:
Subject: Re: [SQL] Determining the DATE format with libpq