M
Michael O'Flaherty
Guest
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:
Here are some values with what should be the approximate date:
Anyone know how to parse these?
Continue reading...
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:
Code:
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...