Forum Discussion
5 Replies
- koryknickEmployee
Can you provide more context around what you are trying to do? Do you need to perform multiple statements in the execute and this is just the first one? Or do you need the current timestamp in the pipeline?
- yes1819New Contributor III
I want to do exact same thing that Oracle PL/SQL does.
In the Oracle, I created Stored Procedure, that’s like below.
This will be the only statement in this snap
- koryknickEmployee
You can add an output view to the Execute snap and use the following in your SQL Statement:
select sysdate as “P_SNAP_DATE” from dual
This will product an output field from the snap as “P_SNAP_DATE” with the current timestamp.
Or, you could do the same thing in a Mapper snap and use Date.now() as the expression.
- yes1819New Contributor III
That worked! Thank you so much!
- koryknickEmployee
Very welcome. Glad it is what you need!