https://www.ptcusercommunity.com/t5/Kepware/datalogger-timestamp/m-p/1051969#M3236 <P>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</P><P>&nbsp;</P><P>Hope this helps someone as distracted as me</P> Thu, 22 Jan 2026 16:37:01 GMT FG_11085366 2026-01-22T16:37:01Z https://www.ptcusercommunity.com/t5/Kepware/datalogger-timestamp/m-p/1051830#M3235 <P>Hi everyone</P><P>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&nbsp;<BR />In SQL I have the column Time as data type: timestamp</P><P>and the data that logs is in hexadecimal, so is not what I want</P><P>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)</P><P>You can see it in the snapshots&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FG_11085366_1-1769026697397.png" style="width: 400px;"><img src="https://www.ptcusercommunity.com/t5/image/serverpage/image-id/133714iAB658C3A52921D01/image-size/medium?v=v2&amp;px=400" role="button" title="FG_11085366_1-1769026697397.png" alt="FG_11085366_1-1769026697397.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FG_11085366_0-1769026654643.png" style="width: 400px;"><img src="https://www.ptcusercommunity.com/t5/image/serverpage/image-id/133713i072B5708BFAB33EB/image-size/medium?v=v2&amp;px=400" role="button" title="FG_11085366_0-1769026654643.png" alt="FG_11085366_0-1769026654643.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>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&nbsp;</P> Wed, 21 Jan 2026 20:19:25 GMT https://www.ptcusercommunity.com/t5/Kepware/datalogger-timestamp/m-p/1051830#M3235 FG_11085366 2026-01-21T20:19:25Z https://www.ptcusercommunity.com/t5/Kepware/datalogger-timestamp/m-p/1051969#M3236 <P>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</P><P>&nbsp;</P><P>Hope this helps someone as distracted as me</P> Thu, 22 Jan 2026 16:37:01 GMT https://www.ptcusercommunity.com/t5/Kepware/datalogger-timestamp/m-p/1051969#M3236 FG_11085366 2026-01-22T16:37:01Z