Convert SQLLite bigint to Date and Time

DECLARE @date AS bigint

SET @date = 130821020250740000

 --For Date use the below Query

SELECT CONVERT(VARCHAR(10),DATEADD(ms, ((@date / CAST(10000 AS bigint)) % 864000) + 7200000,       DATEADD(day, @date / CAST(864000000000 AS bigint), 0)) - 109207, 103) AS [DATE]

--For Time use the below Query

SELECT CONVERT(VARCHAR(10),DATEADD(ms, (@date / CAST(10000 AS bigint)) % 86400000,

  DATEADD(day, @date / CAST(864000000000 AS bigint), 0)) - 109207, 108) AS TIME

 /*SELECT CONVERT(VARCHAR(10),DATEADD(ms, ((@date / CAST(10000 AS bigint)) % 864000) + 7200000,       DATEADD(day, @date / CAST(864000000000 AS bigint), 0)) - 109207, 108) AS TIME*/