Originally posted by: SoftwareDeveloper.india

Hi ,

I got requirement to populate time in milliseconds with 6 digits through currentdatetime function. Function used is Fromdatetime(currentdatetime("{ccyymmdd:hh24.mm.ss.6-6}")

When I am using that function ,I am getting 3 digits only and filling other digits with zero's. Output is "20170908:12.34.23.321000" but I need value as "20170908:12.34.23.123321"

Do wtx has any limitations here populating only 3 of the required 6 digits

Any solution helps a lot.

thanks.

Srujan.

Originally posted by: PaulBrettIBM

This appears to be a limitation of the product with the CURRENTDATETIME() and CURRENTTIME() functions.  3 digits precision only.

Perhaps you would like to raise an enhancement request on the Commerce RFE Community site?

Thank you.

Paul.

Follow me on Twitter

Originally posted by: mladd

It has been a while since I tested this, but I believe Windows only uses 3 fractional seconds. If I recall, The map can only use what the executing system allows. If you were to run that function on a UNIX box, I believe you would see the 6 fractional seconds places. Just not on Windows.

-Mike