Ce contenu n'est pas disponible dans la langue sélectionnée.
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:
| 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 .
