sysdate in the job

arshi · Post by **arshi** » Tue Jun 24, 2008 8:10 am

Hi,

How to get the system time (with time stamp) for all the records when the job started.I need to populate this to target column with data type as DATE.

Any one have the solution please provide.

Regards,
Arshi

ArndW · Post by **ArndW** » Tue Jun 24, 2008 8:25 am

@DATE and @TIME will return the internal format for the date/time when the process was started, DATE() and TIME() will return the date/time of when the function was called.

chulett · Post by **chulett** » Tue Jun 24, 2008 8:29 am

I built a routine to leverage the former and call it in the Initial Value of a stage variable. That sets it once and then I can apply it to all records in the load.