Hi all. Someone here noticed that if you try to get the current time in a stored procedure, the routine only returns the time when that SP started...trying to add time stamps in different parts of an SP and running into this. This creates an issue with a looping SP we have that needs to resolve current time multiple times in the course of other work - it keeps puulling the same time!

Any suggestions?

do you have tried the system command to have the unix time,
or are you on a windows box. On IDS9.xx I think it's possible to use self developped C-functions.