format date and time

Hello!

What the format is for:
1) "xs:dateTime"
2) "xs:time"
3) “xs:date” ?

the examples:
1) “xs:dateTime”
YYYY-MM-DD HH:MM
DD-MM-YYY HH:MM
YY-DD-MM HH:MMpm
YY-DD-MM HH:MMam
??

2) "xs:time"
HH:MM
HH:MMpm
HH:MMam
??

3) "xs:date"
YYYY-MM-DD
YY-MM-DD
??


Questions:

1) How can I define separator for date format?
- “/”
- “-”
- "."

2) How can I define format date for YYYY-MM-DD and how for YY-DD-MM?

3) How can I define format time for HH:MM (eg. 13:29) and how for HH:MM(am, pm) (eg. 01:29pm) ?

In advance, thanks a lot!

best regards,
Dariusz Baumann

I am no expert when it comes to XML Schema data types, but I am afraid, that the most the things you are describing, won’t work this way.

The value spaces and the lexical representations of built-in datatypes can be found here:

http://www.w3.org/TR/xmlschema-2/#built-in-datatypes

Please note, that different representations of the same data type make applications more complex and probably inefficient, that’s why the lexical space of xs:date is restricted to CCYY-MM-DD (see http://www.w3.org/TR/xmlschema-2/#date)

It looks like am, pm for xs:time is not allowed. In this case you have to use something like this:

1:20 pm for Eastern Standard Time which is 5 hours behind Coordinated Universal Time (UTC), one would write: 13:20:00-05:00
(see also: http://www.w3.org/TR/xmlschema-2/#time)

If you really want to create a user-defined datatype, representing date and time formats (I wouldn’t recommend this), then you have to use xs:token as base type, and constrain the value space by using xs:pattern facet (supported with the new Tamino 4.1.1)

Best regards,
Peter