Show Table of Contents
3.5. Date and Time Conversions
JBoss Data Virtualization can implicitly convert properly formatted literal strings to their associated date-related data types as follows:
Table 3.4. Date and Time Conversions
| String Literal Format | Possible Implicit Conversion Type |
|---|---|
| yyyy-mm-dd | DATE |
| hh:mm:ss | TIME |
| yyyy-mm-dd hh:mm:ss.[fff...] | TIMESTAMP |
The formats above are those expected by the JDBC date types. To use other formats see the functions
PARSEDATE , PARSETIME , PARSETIMESTAMP .
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.