This function creates a date from a text a being in the form of a W3CDTF date. Milliseconds are ignored.
If a cannot be parsed and b is specified, the function will fail with error message b. Otherwise, a timestamp with the current date will be returned.
Parameters
Parameter | Description |
|---|---|
a | Date in W3CDTF format (always with data type String). Important note: The parameter expects the specification of the time with time zone! However, a value without a time zone is also tolerated, since this frequently occurs in practical input data. In this case the local setting (system) is assumed, for example Central European Summer Time (CEST). Careful: Up to version 4.0, UTC (Zone Z) was used for this! If a strict W3CDTF format check is desired, the function "create date strict(adjustable template)" should be used instead. |
b | Error message. |
Examples
The examples are based on the local time zone for Germany, i.e. UTC + 1 hour (wintertime) and UTC + 2 hours (daylight saving time). Assume the current date and time 20.08.2011 15:33:23, the local system's timezone is Europe/Berlin.
Parameter a | Parameter b | Result | Note |
|---|---|---|---|
1994-08-05T13:15:30+02:00 | Error while reading | 1994-08-05 13:15:30 (as timestamp with time zone Europe/Berlin) | Daylight saving time. |
1994-11-05T13:15:30+01:00 | Error while reading | 1994-11-05 13:15:30 (as timestamp with time zone Europe/Berlin) | Wintertime. |
1994-08-05T13:15:30Z | Error while reading | 1994-08-05 15:15:30 (as timestamp with time zone Europe/Berlin) | Daylight saving time. |
1994-11-05T13:15:30Z | Error while reading | 1994-11-05 14:15:30 (as timestamp with time zone Europe/Berlin) | Wintertime. |
1994-11-05T13:15:30.852Z | Error while reading | 1994-11-05 14:15:30 (as timestamp with time zone Europe/Berlin) | Milliseconds ignored. |
No date | Error while reading | Function fails with error message Error while reading. | |
No date | 2011-08-20 15:33:23 (as timestamp with time zone Europe/Berlin) | Current time. |
Important note:
The W3CDTF format is used in XML or HTML documents. The XML Schema Definition (XSD) will probably define the data type as date. Hence, importing an XSD will result in a field of type Date or Timestamp. But W3CDTF is not compatible with those data types in Lobster Integration. Please change the type to "String".