We are using MS SQL server as repository to AppManage database.

 

AppManage is storing datetime as a bigint in SQL server vs a regular datetime field. Please recommend the function that can be used to convert this number as valid date as part of regular SQL queries.

 

Following is example of one of the fields that we need to see as Date in our SQL query results for custom reports

 

AM_ManagedObject COLLECTIONTIME = 1281061878306