[Stackoverflow] [Progress OpenEdge ABL] Convert DD-MMM-YYYY HH:MM:SS.SSS to Progress DATETIME-TZ

[Dileep]

Is there an easy way to convert a date time value in format DD-MMM-YYYY HH:MM:SS.SSS to Progress DATETIME-TZ. For example, I am trying to store "15-Sep-2017 20:51:14.566" date in to Progress ABL variable whose datatype is datetime-tz with format "99/99/9999 HH:MM:SS.SSS+HH:MM".

I can get this working by splitting date, month, year, hours, minutes etc to individual variables and combining them using functions like DATE, DATETIME. But, I believe that there should be some good way of doing this. Thanks for your help.

Continue reading...