SAS only has two types of variables, floating point numbers and fixed length character strings.  To allow you to work with datetime values SAS has some formats, informats and functions that treat the number of seconds since 1960 as a datetime value.  But they do not have any concept of storing an offset from GMT in addition to the number of seconds.  So for this data to even be usable in SAS you will have to transform it in some way.  For example you could eliminate the offset by adjusting the value into either GMT or the servers local time.  I assume that is what you say worked for you.  Or you could translate it into a string that include the datetime value and the offset.  Or store the offset and datetime value as two separate variables.   It sounds like the OLEDB driver you are using does not know how to convert that data type for you. You might try using the DBSASTYPE= dataset option and see if SAS will cast the value to a character string that you can read. ... View more