Conversion rules from string to date

When you convert a string value to a date value, you must follow certain conversion rules.

The conversion rules are as follows:

• If you specify all numeric format model elements, including leading zeros, you can omit the punctuation marks in the format string from the date string. For example, specify 02 instead of 2 for two-digit format elements such as MM, DD, and YY.

• You can omit the time fields that are found at the end of the format string from the date string.

• You can use any nonalphabetic numeric character in the date string to match the punctuation marks in the format string.