Extract datetime from reverse Time stamp.

[Manjula mohapatra]

My rowkey contains reverseTimestamp ( Max value - current time stamp)
Example  9223370646332874562



select FROM_UNIXTIME ( unix_timestamp(
'9223370646332874562','yyyyMMddHHmmssSSS'))
    > from HiveTest limit 1;

9226-01-07 22:34:42    --obviously this wont give me right result as its
reverse time stamp.

Max value - current time stamp