Well to be clear,  its not the UserType that is an issue.  It's the fact that it's a composite value (a tuple).   At the db level this is casting the (TIMESTAMP, VARCHAR) to a Date which of course is not valid.

To be honest I am inclined to either reject this as a bug or to reclassify it as an enhancement request for a new operator


On Fri, Oct 30, 2015, 8:09 AM Christian Beikov (JIRA) <jira@hibernate.atlassian.net> wrote:
Christian Beikov commented on Bug HHH-9459
 
Re: Cast function in HQL query for custom user type for DateTime data type

Good to know, I was unaware of that. Well in that case the user needs something like the following

select e from MyEntity where :now >= cast(e.startDate.dateTime as date)

The path e.startDate.dateTime would then resolve to a non-usertype which works for cast.

Add Comment Add Comment
 
This message was sent by Atlassian JIRA (v7.0.0-OD-08-002#70107-sha1:3f098e8)
Atlassian logo
_______________________________________________
hibernate-issues mailing list
hibernate-issues@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-issues