load script - get actual time with milliseconds

[#1]

Hi,

how is it possible to get the actual time with milliseconds in the load script. I need to query the time (like the function now()) but with the precision of milliseconds.

Thanks in advance

[#2]

Hi Rabbit,

Unfortunately the now() function only returns timestamp to the second... even when attempting to reformat with fff (which should show fractions of a second to 3 decimal places).

The only way I could get millisecs was to:
1_ execute an external command that stores the current timestamp in a file
2_ read the file into a table
3_ peek to get the value into a variable.

Perhaps someone else on the forum could come up with a solution using macros...

[#3]

In the load script, we run an EXECUTE command to create the mydate.txt file.

In order for this to run correctly, you need to make sure that the "Can Execute External Programs" box is checked on the load script settings tab.

Also, be sure to click the "Give System Access" button that pops up when you reload. I haven't tested this on server yet, so I'm not sure if it will requrie additional setup.

[rwunderlich]

You can use the VBScript Timer function in a macro function and call that from the load script. See attached.

-Rob

(Caution QVS SR4 has problems with custom macro functions - bug #27945)