[progress Communities] [progress Openedge Abl] Forum Post: Jdbc Inserting A Formatted Date...

  • Thread starter Thread starter MABeatty1978
  • Start date Start date
Status
Not open for further replies.
M

MABeatty1978

Guest
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

Continue reading...
 
Status
Not open for further replies.
Back
Top