Note: For new profile implementations, please use function "create date strict(template)" instead.
Returns a timestamp based on the value in a and the format template b. If in the error case the value cannot be parsed, the result of the function is the current date with set Empty Flag. If a already has the data type "Timestamp" or "Date", a conversion is not necessary. In this case, parameter b has to remain empty.
Parameters
Parameter | Description |
|---|---|
a | Text to be interpreted. If the text cannot be interpreted, the function returns the current date with set Empty Flag. Note: If an actual "Date" or "Timestamp" object is specified here instead of a text, parameter b has to remain empty. |
b | The date format template. |
Examples
Current date of this example: "2011-10-20 15:33:23.0".
Parameter a | Parameter b | Result |
|---|---|---|
241205 | ddMMyyHHmm | 2011-10-20 15:33:23.0 |
No date | ddMMyyHHmm | 2011-10-20 15:33:23.0 |
2412050820 | ddMMyyHHmm | 2005-12-24 08:20:00.0 |
1997-07-16T19:20:30Z (see format template W3CDTF) | W3C | 1997-07-16 21:20:30.0 |