[hibernate-issues] [JIRA] (HHH-15659) Time zone format issue resulting in "ORA-01830: date format picture ends before converting entire input string"

abhijith ca ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63636a0... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDJjMGJlZjEy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15659?atlOrigin=eyJpIjoiZDJjMG... ) HHH-15659 ( https://hibernate.atlassian.net/browse/HHH-15659?atlOrigin=eyJpIjoiZDJjMG... ) Time zone format issue resulting in "ORA-01830: date format picture ends before converting entire input string" ( https://hibernate.atlassian.net/browse/HHH-15659?atlOrigin=eyJpIjoiZDJjMG... ) Issue Type: Bug Affects Versions: 5.3.10 Assignee: Unassigned Components: query-sql Created: 03/Nov/2022 00:49 AM Environment: hibernate-core.jar:5.3.10, JDK 1.8, RHEL7, Oracle 18.9.0.0.0 Priority: Major Reporter: abhijith ca ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63636a0... ) We are sending data in the format “27-Oct-22 03.48.33.000000427 PM Asia/Singapore” via hibernate query to oracle Database and column receiving this data in db is of data type “TIMESTAMP(0) WITH TIME ZONE”. This is working fine in RHEL7 server S1 and same code is not working in S2 server and resulting in an error "ORA-01830: date format picture ends before converting entire input string". The parameters set in both servers are same and code is also same but still when we fail over to S2 sever we are facing this issue. On debugging at oracle end we have identified conversion of below functions might be an issue. select to_timestamp_tz('28-Oct-22 04.12.38.000000850 PM Asia/Singapore','DD-MON-RR HH24.MI.SSXFF TZR') from dual; Output: ORA-01830: date format picture ends before converting entire input string select to_timestamp_tz('28-Oct-22 04.12.38.000000850 PM Asia/Singapore','DD-MON-RR HH.MI.SSXFF PM TZR') from dual; Output: TO_TIMESTAMP_TZ('28-OCT-2204.12.38.000000850PMASIA/SINGAPORE','DD-MON-RRHH. 28-OCT-22 04.12.38.000000850 PM ASIA/SINGAPORE Any pointers as why this might be happening ( https://hibernate.atlassian.net/browse/HHH-15659#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15659#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#100210- sha1:a51bb46 )