datalogger timestamp

[FG_11085366]

Hi everyone

Basically I'm trying to log data into an SQL server, I get the correct tag value and tag name, but with the time I'm not able to see it correctly in SQL 
In SQL I have the column Time as data type: timestamp

and the data that logs is in hexadecimal, so is not what I want

I've actually use data type datetime2 as well in sql but then I get an error in Kepware (Error Data Logger Plug-in Unable to query recordset on Log Group 'loggroup'. Reason: Conversion failed when converting date and/or time from character string)

You can see it in the snapshots 

does anyone know how can I actually submit the time in the SQL server? or like what datatype should be in Kepware and SQL? please help 

[FG_11085366 · Accepted solution]

The answer was really simple, just added a new column in my SQL with datatype "datetime" and changed the Database Field Name to the new column with datatype "datetime" and worked, I know it sounds really simple but I was dumb enough to make it bad the first time lol

Hope this helps someone as distracted as me