JDBC inserting a formatted date time into datetime field - Forum - OpenEdge Development - Progress Community

JDBC inserting a formatted date time into datetime field

 Forum

JDBC inserting a formatted date time into datetime field

This question is not answered

I have a java application that is putting a datetime value into a datetime field of a Progress db.

The java value is in yyyy-mm-ddT15:00:00.000-04:00 format

The format of the date time field is 9999-99-99 HH:MM:SS.SSS+HH:MM

I apply a SimpleDateFormat to the string as "yyyy-MM-dd HH:mm:ss.SSSXXX" to the value when inserting it into the database.  I can see the string value being inserted is: 2017-03-20 15:00:00.000-04:00 however, I'm getting an Invalid time string (7500) error.

Any help would be appreciated.  Thank you

All Replies
  • I've removed the time zone from the string, "yyyy-MM-dd HH:mm:ss.SSS" and it inserts correctly into the database, so I know the issue is with the timezone format.  Any advice on how to fix the time zone?

  • Columns of the type datetime (called “timestamp” in SQL) do not include time zone information.

    Columns of the type datetime-tz (called “timestamp with time zone”) DO have time zone information.