Display windows perfmon data using MSSQL DB

i'm saving MS perfmon data into a MSSQL db. Perfmon is automatically creating a db that have 3 tables
1. CounterData   ( GUID,[int]CounterId,[char(24)]CounterDateTime )
2. CounterDetails ([int]CounterID,[varchar(1024)]MachineName,[varchar(1024)]CounterName,[varchar(1024)]ObjectName)
3. DisplaytoID   (GUID,[int]MinutestoUTC)

when i'm using a simple table panel with the following sql query the data is showed
SELECT
MachineName,
CounterValue,
CounterDateTime,
CounterName,
ObjectName
>      
 
FROM CounterDetails
  INNER JOIN CounterData ON CounterDetails.CounterID = CounterData.CounterID
  INNER JOIN DisplayToID on DisplayToID.GUID = CounterData.GUID
   
WHERE $__timeFilter(CounterDateTime) AND MachineName in($hostname)

ORDER BY 1

But when i’m trying to have a Graph setting " format as" Time Series i doesn’t show anything . I think the reason why is because the CounterDateTime column is NOT in datetime type but

  1. i’m not sure of it
  2. don’t have any idea how to convert it