[midPoint] ScriptedSQL livesync, date/time column format

[Jason Everling]

When using livesync for scriptedsql conntector and database is ms sql
server how should the modified column be formatted.

Right now I setup the 'modified' column with a trigger on insert/update to
populate using GETDATE() which populates like 2017-01-25 10:32:02.107

Within the livesync task it seems to be updating rows with every sync task
and I am assuming it is because of the date/time format.

My script looks like this basically, except mine has the right column names
of course for the query

https://github.com/Evolveum/midpoint/blob/d8aec0b6ae5c03009a2a703533f1637852a3b8ad/samples/resources/scriptedsql/SyncScript.groovy

Any insights would be appreciated!

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170125/d1d32780/attachment.htm>