<p dir="ltr">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.</p>
<p dir="ltr">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</p>
<br><div class="gmail_quote"><div dir="ltr">On Fri, Oct 30, 2015, 8:09 AM Christian Beikov (JIRA) <<a href="mailto:jira@hibernate.atlassian.net">jira@hibernate.atlassian.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div style="color:#333;font-family:Arial,sans-serif;font-size:14px;line-height:1.429">
<table cellpadding="0" cellspacing="0" width="100%" style="border-collapse:collapse;background-color:#f5f5f5;border-collapse:collapse">
<tr>
<td style="padding:0px;border-collapse:collapse;padding:10px 20px">
<table cellspacing="0" cellpadding="0" border="0" style="border-collapse:collapse">
<tr>
<td valign="top" style="padding:0px;border-collapse:collapse;vertical-align:top;width:32px;padding-right:8px"> <img src="https://secure.gravatar.com/avatar/0a81b8b5d21688d12a820dd0516853fd?d=mm&s=48" height="32" width="32" border="0" style="border-radius:3px;vertical-align:top">
</td>
<td valign="middle" style="padding:0px;border-collapse:collapse;vertical-align:middle;font-family:Arial,sans-serif;font-size:14px;line-height:20px"> <a rel="christian.beikov" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=christian.beikov" style="color:#6c797f;color:#3b73af;text-decoration:none" target="_blank">Christian Beikov</a> <strong>commented</strong> on <a href="https://hibernate.atlassian.net/browse/HHH-9459" style="color:#3b73af;text-decoration:none" target="_blank"><img height="16" width="16" border="0" align="absmiddle" alt="Bug"> HHH-9459</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:0px;border-collapse:collapse;padding:0 20px">
<table cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse:collapse;border-spacing:0;border-collapse:separate">
<tr>
<td style="padding:0px;border-collapse:collapse;color:#fff;padding:0 15px 0 16px;height:15px;background-color:#fff;border-left:1px solid #ccc;border-top:1px solid #ccc;border-right:1px solid #ccc;border-bottom:0;border-top-right-radius:5px;border-top-left-radius:5px;height:10px;line-height:10px;padding:0 15px 0 16px">
</td>
</tr>
<tr>
<td style="padding:0px;border-collapse:collapse;border-left:1px solid #ccc;border-right:1px solid #ccc;border-top:0;border-bottom:0;padding:0 15px 0 16px;background-color:#fff">
<table cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse:collapse">
<tr>
<td style="vertical-align:top;padding:0px;border-collapse:collapse;padding-right:5px;font-size:20px;line-height:30px"> <span style="font-family:Arial,sans-serif;padding:0;font-size:20px;line-height:30px;vertical-align:middle"> <a href="https://hibernate.atlassian.net/browse/HHH-9459" style="color:#3b73af;text-decoration:none" target="_blank">Re: Cast function in HQL query for custom user type for DateTime data type</a> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:0px;border-collapse:collapse;border-left:1px solid #ccc;border-right:1px solid #ccc;border-top:0;border-bottom:0;padding:0 15px 0 16px;background-color:#fff;border-bottom:none;padding-bottom:0">
<table cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse:collapse;font-family:Arial,sans-serif;font-size:14px;line-height:20px">
<tr>
<td style="padding:0px;border-collapse:collapse;padding:0 0 10px 0">
<p style="margin:10px 0 0 0">Good to know, I was unaware of that. Well in that case the user needs something like the following</p>
<div style="border-width:1px;border:1px solid #ccc;background:#f5f5f5;font-size:12px;line-height:1.333;font-family:monospace;border:1px solid #ccc;border-radius:3px 3px 3px 3px;margin:9px 0">
<div style="padding:9px 12px">
<pre style="margin:10px 0 0 0;max-height:30em;overflow:auto;white-space:pre-wrap;word-wrap:normal">
<span style="color:#000091">select</span> e <span style="color:#000091">from</span> MyEntity <span style="color:#000091">where</span> :now >= cast(e.startDate.dateTime as date)
</pre>
</div>
</div>
<p style="margin:10px 0 0 0">The path <b>e.startDate.dateTime</b> would then resolve to a non-usertype which works for cast.</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:0px;border-collapse:collapse;border-left:1px solid #ccc;border-right:1px solid #ccc;border-top:0;border-bottom:0;padding:0 15px 0 16px;background-color:#fff">
<table cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse:collapse;font-family:Arial,sans-serif;font-size:14px;line-height:20px">
<tr>
<td valign="middle" style="padding:0px;border-collapse:collapse;padding:10px 0 10px 24px;vertical-align:middle;padding-left:0">
<table align="left" style="border-collapse:collapse">
<tr>
<td style="padding:0px;border-collapse:collapse;font-family:Arial,sans-serif;font-size:14px;line-height:20px;vertical-align:middle"> <a href="https://hibernate.atlassian.net/browse/HHH-9459#add-comment" title="Add Comment" style="color:#3b73af;text-decoration:none" target="_blank"> <img alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align:middle"> </a>
</td>
<td style="padding:0px;border-collapse:collapse;font-family:Arial,sans-serif;font-size:14px;line-height:20px;padding-left:5px"> <a href="https://hibernate.atlassian.net/browse/HHH-9459#add-comment" title="Add Comment" style="color:#3b73af;text-decoration:none" target="_blank">Add Comment</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:0px;border-collapse:collapse;color:#fff;padding:0 15px 0 16px;height:5px;line-height:5px;background-color:#fff;border-top:0;border-left:1px solid #ccc;border-bottom:1px solid #ccc;border-right:1px solid #ccc;border-bottom-right-radius:5px;border-bottom-left-radius:5px">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:0px;border-collapse:collapse;padding:12px 20px">
<table cellspacing="0" cellpadding="0" border="0" style="border-collapse:collapse">
<tr>
<td width="100%" style="padding:0px;border-collapse:collapse;color:#999;font-size:12px;line-height:18px;font-family:Arial,sans-serif">
This message was sent by Atlassian JIRA <span>(v7.0.0-OD-08-002#70107-<span title="3f098e887822d12897dbfd77339d1bc8b3ef240b">sha1:3f098e8</span>)</span>
</td>
<td valign="top" style="padding:0px;border-collapse:collapse;padding-left:20px;vertical-align:top">
<table style="border-collapse:collapse">
<tr>
<td style="padding:0px;border-collapse:collapse;padding-top:3px"> <img alt="Atlassian logo" title="Atlassian logo" width="169" height="36">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
_______________________________________________<br>
hibernate-issues mailing list<br>
<a href="mailto:hibernate-issues@lists.jboss.org" target="_blank">hibernate-issues@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/hibernate-issues" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/hibernate-issues</a></blockquote></div>