Hello

2011/1/1 Esmin Gracic <[email protected]>:
> 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');
>

xsd define format for date, so you have to use a to_char function or
just cast to text.

Regards

Pavel Stehule

> 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ć
>

-- 
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to