Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGY3OTczNjg3... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16185?atlOrigin=eyJpIjoiNGY3OT... ) HHH-16185 ( https://hibernate.atlassian.net/browse/HHH-16185?atlOrigin=eyJpIjoiNGY3OT... ) Standardize the date_trunc() function, emulating it for Dialects that don't support native versions ( https://hibernate.atlassian.net/browse/HHH-16185?atlOrigin=eyJpIjoiNGY3OT... ) Issue Type: Improvement Assignee: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) Created: 15/Feb/2023 05:26 AM Priority: Minor Reporter: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) We should standardize the date_trunc() function, making it available for use to all Dialects. HSQLDB supports a trunc() function similar to Oracle and DB2. Microsoft SQL Server supports a datetrunc() function since version 16. Dialects that don't have a viable native function can use an emulation that leverages formatting the datetime to string and parsing back after truncating to the correct Temporal Unit. Also, fix the use of the function trunc() in Oracle and DB2 that requires transforming the Temporal Unit into a different format for most cases. ( https://hibernate.atlassian.net/browse/HHH-16185#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16185#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#100216- sha1:a1e7611 )