DSXchange

Hi,

We are using the following function to populate date with corresponding timestamp in one of the fields

"Oconv(Date(),"DYMD"):Oconv(@TIME,"MTS")"

The function gives correct results but for a job whose execution started at 11:55 PM on 3rd March and ended at 12:05 AM 4th Mar, we got the following two values as the Last_Update_Date:
11:55:06PM 03-Mar-2009 and
11:55:06PM 04-Mar-2009

The first value is correct but the second value is wrong.

Can any body please explain as why are we facing this issue and what could be the potential solution?

Thanks a lot in advance.

Try Time() instead of @Time

The reason behind Sainath's suggestion is that @TIME is set when the job starts, whereas Time() captures the system clock value at the moment it is invoked.