Possible way to convert Timestamps stored in SQL tables as BIGINT into readable date-time format

  • Article

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

Example:

select [dbo] . [fnTicksToDate] (634199505290117946)

returns:

2010-09-13 04:55:29.010

Hope this helps.