select [dbo] . [fnTicksToDate] (<timestamp in BIGINT format>)

Example:

select [dbo] . [fnTicksToDate] (634199505290117946)

returns:

2010-09-13 04:55:29.010

Hope this helps.