Incorrect date format
Hi,
My requirement is to pass the date as a string “YYYY/MM/DD HH:MI:SS” as a parameter to Oracle procedure snap. I amssusing the expression - Date.now().toLocaleDateString({“format”:“yyyy/MM/dd HH...
Forum Discussion
“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.” - this shouldn’t happen.
From the screen I can see that the date is mapped from input(“$p_processing_date”). It is not taken from parameter.
If you try to parse the value from parameter as date back, then you will get the “2022-06-13T12:03:38.000Z”.
So, if you procedure expect the field as date, probably you will need to handle the date conversion and format on procedure level. Otherwise, you can pass the field as string(without parsing back as date), directly from parameter: _p_processing_date
BR,
Spiro Taleski
Actually, it’s passed from parameter only, please see below and I couldn’t understand what do you mean by _p_processing_date and where I have to pass it?
what do you mean by _p_processing_date
In SnapLogic terminology:
- when you reference a field, it is prefaced with the dollar sign ($)
- when you reference a parameter (which is defined in the pipeline properties), it is prefaced with the underscore (_). Parameters are strings.
So if the p_processing_date was a parameter, you would use _p_processing_date.
In this case, you are mapping a date to a field.
