Is there a way to force the transaction group to update the timestamps with smalldatetime instead of datetime in a MSSQL database?
Would I have to use a stored procedure to convert it to smalldatetime?
Never mind, I found that I was using ‘yyyy-mm-dd…’ instead of ‘yyyy-MM-dd…’ to create my timestamp tag and this was causing the date to upload incorrectly.
I found that I can simply change the datatype to smalldatetime in the database after the transaction group has created the table.