How to get the last modified time of a document in sharepoint?

Question

How to convert LastModifiedTime value to MssCrawlUrl table?

I tried the request below,

Select CAST(LastModifiedTime as datetime)
From MssCrawlUrl Where DisplayURL like '<DisplayURL>'

But he gives an error

'An arithmetic overflow error converting an expression to a datetime data type.'

Answer 1

SharePoint. API. "" , , , . . , ! Microsoft.

Visual How To API. . MSDN .

Answer 2

ans

DECLARE @dt AS bigint
SET @dt = <BIGINT>
SELECT DATEADD(ms, (@dt / CAST(10000 AS bigint)) % 86400000,
DATEADD(day, @dt / CAST(864000000000 AS bigint) - 109207, 0))