Can anyone explain how dates are stored in service desk plus.

 

I wish to write a native MS SQL query that interprets dates which are stored as data type BIGINT in MS SQL Server.

 

I read somewhere that it is the number of milliseconds since 1 Jan 1970 but MSSQL server DATEDIFF function cannot handle a BIGINT value so I assume some other method is used to convert from the BIGINT value to a valid date.

 

Cheers

 

Jeff