[Stackoverflow] [Progress OpenEdge ABL] Progress to SQL Server Datetime Conversion with Pro2

[Michael O'Flaherty]

We are using Pro2 to sync data from Progress to SQL Server. However, some datetime (or datetime offsets) are being converted into int32 and we cannot figure out the conversion. We have asked Progress but no reply. Curious if anyone is familiar with this.

I have found various articles regarding Oracle, Epoch, Julian, etc. but no definitive answers. Reference: Working with MS SQL Server and ABL datetime data types (progress.com)

For time columns, it is fairly straightforward. This code works:

select cast(dateadd(s, 86055, '00:00:00') as time(0)) -- returns 23:54:15

Here are some values with what should be the approximate date:

• 966188916 -- should be approx. 4/12/2010
• 1091012202 -- should be approx. 7/28/2014

Anyone know how to parse these?

Continue reading...