JPQL date literrals: documentation error


stephane
 

Regarding date format, there is a error in the documentation. Month are specified as 'mm' like minutes. It would be better to mention MM (looks like SimpledateFormat)

JPQL supports literals of the following types : Number, boolean, character, String, NULL and temporal. When String literals are specified using single-string format they should be surrounded by single-quotes '. Please note that temporal literals are specified using JDBC escape syntax in String form, namely

{d 'yyyy-mm-dd'}                 - a Date
{t 'hh:mm:ss'}                   - a Time
{ts 'yyyy-mm-dd hh:mm:ss.f...'}  - a Timestamp
--
Stephane

Join main@datanucleus.groups.io to automatically receive all group messages.