Skip site navigation (1) Skip section navigation (2)

correct format for date, time, timestamp for XML functionality

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: peter_e(at)gmx(dot)net
Subject: correct format for date, time, timestamp for XML functionality
Date: 2007-02-20 12:27:42
Message-ID: BAY20-F16759729A19125DBB4076AF9890@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-patches
Hello,

this patch ensures independency datetime fields on current datestyle 
setting. Add new internal datestyle USE_XSD_DATESTYLE. It's almoust same to 
USE_ISO_DATESTYLE. Differences are for timestamp:

ISO: yyyy-mm-dd hh24:mi:ss
XSD: yyyy-mm-ddThh24:mi:ss

I found one link about this topic: 
http://forums.oracle.com/forums/thread.jspa?threadID=467278&tstart=0

Regards
Pavel Stehule

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. 
http://messenger.msn.cz/

Attachment: datetime_for_xml.diff
Description: text/x-patch (7.0 KB)

Responses

pgsql-patches by date

Next:From: Greg SmithDate: 2007-02-20 13:16:51
Subject: Re: [PATCHES] WIP patch - INSERT-able log statements
Previous:From: Zoltan BoszormenyiDate: 2007-02-20 10:27:42
Subject: New version of IDENTITY/GENERATED

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group