Here is a list of valid character string representations when the implicit or explicit character-to-period conversion uses the ANSI DateTime format to interpret the beginning and ending bound elements.
- '('' beginning_element_value '' ,Δ'' ending_element_value '')'
- '(beginning_element_value , Δending_element_value )'
- '(''beginning_element_value '', Δending_element_value )'
- '(beginning_element_value , Δ''ending_element_value '')'
where formats of beginning_element_value and ending_element_value depend on the target data type.
| Target Data Type | Format |
|---|---|
| PERIOD(DATE) | YYYY-MM-DD |
| PERIOD(TIME[(n)]) | HH:MI:SS.S(F) |
| PERIOD(TIMESTAMP[(n)]) | YYYY-MM-DDBHH:MI:SS.S(F) |