create date(template)
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 |