To the right there are a series of simple checks, do not let the mass of text or regex scare you.
Lets take a look:
- First, the date and time field need to be combined in the element 'value' before the checks can be done
Then:
- The first match checks to see if the datetime is an empty string, and if so, sets it to null
- The second match checks to see if the datetime contains only a date. If so, the appropriate text for the SQL function to convert it to a time stamp is set.
- The third match checks to see if the datetime contains only a time. If so, the appropriate text for the SQL function to convert it to a time stamp is set.
- The forth match checks to see if the datetime contains both a date and time. If so, the appropriate text for the SQL function to convert it to a time stamp is set.
- The fifth match checks to see if we have reset the parameter to either null or a string beginning with 'TIMESTAMP_FORMAT' if an error is not raised as was done with the maximum invocations.
Steps to complete:
- Make the changes to your document as indicated on the right