[midPoint] ScriptedSQL livesync, date/time column format

Pálos Gustáv gustav.palos at evolveum.com
Wed Jan 25 17:55:42 CET 2017


Hi Jason,

In one of my customer I use for this "timestamp" in MS SQL VIEW and
calculated with this:
DATEDIFF(SECOND, CONVERT(DATETIME, '1970-01-01', 102), LastChange) as
LastChangeTimestamp

Best regards,

Gustav


2017-01-25 17:35 GMT+01:00 Jason Everling <jeverling at bshp.edu>:

> 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/d8aec0b6ae5c03009a2a703533f163
> 7852a3b8ad/samples/resources/scriptedsql/SyncScript.groovy
>
> Any insights would be appreciated!
>
> Thanks!
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>


-- 
Gustáv Pálos
Identity Engineer
evolveum.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170125/1de179ab/attachment.htm>


More information about the midPoint mailing list