Forum Discussion

bigdogz's avatar
bigdogz
New Contributor
5 years ago
Solved

SQL Server No Rows Control Flow

Newbie with Snap Logic. I’m attempting to build an integration that will run once a day. The input is coming from a SQL Server database. There will be days when there will be no data to process...
  • jaybodra's avatar
    7 years ago

    @virender.prajapati I have seen this happening to me in MySQL. I used toLocalDateTimeString() function before inserting it into the DB and worked fine.

    You can try this in your mapper,
    Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0).toLocaleDateTimeString({“format”: “yyyy-MM-dd HH:mm:ss”,“timeZone”:“UTC”})

    You can also look into oracle jdbc url properties