Errors using TIMESPAN from SQL server when implementing a single stat diagram

I receive the error:

Invalid type for column time, must be of type timestamp or unix timestamp

When I enter the following SQL statement into Graffana:

SELECT
  time,
  Ammount as metric
FROM
  ConnectedUsers

The time column within my SQL Server is a timestamp data type and contains values such as: 0x00000000000013AE

Any help with resolving this error would be much appreciated!