IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  format date and time

    Posted 01/14/03 01:09 PM

    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


    #Tamino
    #API-Management
    #webMethods


  • 2.  RE: format date and time

    Posted 01/14/03 02:42 PM

    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


    #API-Management
    #Tamino
    #webMethods