[Squirrel-sql-users] Date/time format in the generated insert into script for SQL Server

[Alex M. <ale...@bl...>]

When generating an INSERT-INTO script from the result of a select statement, the DATETIME column values come across as follows:



{ts '2017-02-24 10:56:12.790000'}



The correct format would be as follows:



'2017-02-24 10:56:12.790'



In the settings I can see that the above format is supposed to be used for timestamps in WHERE clauses, but it seems to be used for datetime of the VALUES clause as well.

Changing the setting below does not seem to have any impact on the VALUES.



[cid:image001.png@01D2E9B4.FFD01DE0]



Also, BIT fields come across as 'true' or 'false' which confuses SQL Server when this executes. Can those be changed to 1/0?



Thank you!

Alex



SQuirreL SQL Client Version 3.7.1