-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
4.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
.