bigdogz
5 years agoNew Contributor
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...
- 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