Use last run datetime in data source

[Amanjyot Oberoi]

Hi Folks,

We have integrated SQL anywhere using data source. We are trying to leverage "Use last run datetime", so that we could import delta values only after the first time load into the import set table. 

The problem is that in SQL anywhere the date is stored in epoch (bigint) format. Any pointers please?

Thanks

[Ankur Bawiskar]

Hi Aman,

Following link should be helpful:

https://community.servicenow.com/community?id=community_article&sys_id=d4fc62a5dbd0dbc01dcaf3231f961935

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Amanjyot Oberoi]

Thanks, went through that post, was just wondering about the change made to the BR!

[Ankur Bawiskar]

Hi Aman,

I wonder if anyone has done this before. For Oracle I think it works fine.

What database you are connecting to?

Regards

Ankur

[Ankur Bawiskar]

Hi Aman,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur