|
From: Gerd W. <ger...@t-...> - 2022-02-20 22:10:28
|
Am 17.02.22 um 18:11 schrieb Kevin Dziulko via Squirrel-sql-users:
> Under Global Preferences -> Data Type Controls, I have the following
> option enabled:
> () Use String version of Timestamp ('2022-02-17 11:56:16.449')
>
> Then when I run a SELECT statement that involves a timestamp column, and
> do a ctrl+t and use the sql2ins command, the generated INSERT statement
> contains the "{ts }".
>
> Is this a bug? How do I make the generated INSERT statement NOT contain
> the "{ts }"?
>
As the UI says this option is used for internally generated WHERE
clauses only.
I just committed a change that should meet your needs. Excerpt from
change log:
Scripting of the data types TIMESTAMP, DATE, TIME can now be chosen to
use the standard JDBC format, e.g. {ts '2022-02-20 22:41:47'}, or a
string version, e.g. '2022-02-20 22:41:47'. The format can be chosen at
menu File --> Global Preferences --> tab Data Type Controls --> sections
Timestamp, Date, Time --> Panels titled "For script generation"
I'm just uploading a new snapshot with the feature. See
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20220220_2301/
Gerd
|
