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*/