[hibernate-issues] [JIRA] (HHH-16723) Add a way to make custom type sql code to be treated as temporal

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2I4N2M1ODg3... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) HHH-16723 ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) Add a way to make custom type sql code to be treated as temporal ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) Issue Type: Improvement Assignee: Unassigned Created: 30/May/2023 09:23 AM Environment: Hibernate 6.2.3.Final, Adoptium 17 JDK, Oracle 19.3 Priority: Major Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It is not possible at the moment to create custom temporal type (see org.hibernate.type.SqlTypes.isTemporalType ) . Some hook should be added to allow custom type code to be treated as temporal. This is important as arguments in HQL functions are now validated and this prevents proper validation for custom types that should be temporal . Concretely oracle has timestamp with local time zone type that currently needs this. ( https://hibernate.atlassian.net/browse/HHH-16723#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16723#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:d82e018 )