xml queries & date format

From: Jef Peeraer <jef(dot)peeraer(at)telenet(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: xml queries & date format
Date: 2008-09-05 09:39:41
Message-ID: Pine.LNX.4.64.0809051132140.4914@minas.objectit
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


i am using the xml add-ons, but the date output format seems to be wrong :
i have
show datestyle;
DateStyle
-----------
SQL, DMY

select agenda_datum from dossiers where id = 61;
agenda_datum
--------------
29/07/2008

select table_to_xml('dossiers', false, false, '');
gives (knip )
<row>
<id>62</id>
<voorwerp_detail>5 coils 5.622 kg</voorwerp_detail>
<schade_datum>2008-07-29</schade_datum>
<voorbehoud>false</voorbehoud>
<protest>false</protest>
<vordering>false</vordering>
<afgewezen>false</afgewezen>
<gedeeltelijk_afgewezen>false</gedeeltelijk_afgewezen>
<verhaal>false</verhaal>
<administratief>false</administratief>
</row>

jef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2008-09-05 09:44:50 Re: Cannot connect to server
Previous Message Ow Mun Heng 2008-09-05 08:58:20 Re: max_stack_depth Exceeded