Postgres Pro
Downloads
Home   >   mailing lists

query_to_xml function ignores Datestyle? - Mailing list pgsql-general

From Esmin Gracic
Subject query_to_xml function ignores Datestyle?
Date
Msg-id AANLkTinV4u4j87xotf67yJGCJiu-OFc-pCS7CNJxUr=j@mail.gmail.com
Whole thread Raw
Responses Re: query_to_xml function ignores Datestyle?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
It seems that query_to_xml function ignores Datestyle settings?
Is this correct? If yes, is there any workarounf except to_char(date,'dd.mm.yyyy');

set datestyle = 'German';
select current_date;
select QUERY_TO_XML('select current_date',true,false,'');


Postgresql 9.0 on Ubuntu 10.04 Server (64-bit)

Esmin Gracić

pgsql-general by date:

Previous
From: tuanhoanganh
Date:
Subject: Re: Stream Replication archive command Access is denied question
Next
From: Pavel Stehule
Date:
Subject: Re: query_to_xml function ignores Datestyle?