how to use Date data type ?

[Former Member]

Hi @,

I have to use date type in my datatype but the format for the same is different and i dont know where to specify the same please help?

Also how to define datetime type with format yyyy-mm-dd.Thh:mm:ss ?

If there any place to specify the format ? I have defined it in pattern ?please correct

Regards

[Former Member]

Hi,

We have to external XSDs for date format

In that we can specify using regular expression like

<xs:element name="DateInput">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:pattern value="[0-3][0-9][/][0-1][0-9][/][0-2][0-2][0-9][0-9]"/>

</xs:restriction>

</xs:simpleType>

</xs:element>

Regards,

Sai

[Former Member]

Hi

I guess you can do it message mapping by defining source and destination date types, using date functions currentDate, DateTrans, DateBefore, DateAfter, CompareDates

By default, format of date is

xsd:date

Value is interpreted as date in format CCYY-MM-DD (according to the enhanced representation of ISO 8601).

The abbreviations mean the following:

CC: Century

YY: Year

MM: Month

DD: Day

Regards,

Sai

[Former Member]

HI sai,

If we have to use some other data formate like mm-dd-yyyy then how to use this type?

Regards