Forum Discussion

yes1819's avatar
yes1819
New Contributor III
5 years ago

Oracle SQL Declare a column and select today's date into the column

Hi I need to put today’s date in a column called “P_SNAP_DATE” Oracle stored procedure Execute Immediate ‘select sysdate from dual’ into P_SNAP_DATE was working fine in the Oracle. When I p...
koryknick's avatar
koryknick
Employee
5 years ago

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.