Forum Discussion

BarryStarck's avatar
BarryStarck
New Contributor II
3 years ago

Filter and Edit a JSON with a touch of data manipulation

Hi, I need to amend some data for a specific table flowing through one of my pipelines This specific json contains multiple values for example: L_TYPE “A” L_TYPE “A” L_TYPE “A” L_TYPE “B”...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
4 years ago
Copy LinkReport

@amit.saroha

What are the additional characters that you are getting?

The first screen date 2022/06/13 11:57:32 looks fine.

The second one 2022-06-13T12:03:38.000Z has completely different format.

BR,
Spiro Taleski

amit_saroha's avatar
amit_saroha
New Contributor III
4 years ago
Copy LinkReport

Yes, when it’s passed as a parameter to Oracle Procedure Snap it changed to 2022/06/13 11:57:32 > 2022-06-13T12:03:38.000Z.

Any way to keep it as 2022/06/13 11:57:32?