How to use DateTime Util/DateTime Variable capture Second and Millisecond value?
I need to insert logs to database, one of the data field needed is the Transaction Start Time, I used below methods to capture the DateTime Value, but when it pass to database (Microsoft SQL Server), it does not have Second and Millisecond Value.
Could anyone please help to guide how to correct? thanks!!!
Pegasystems Inc.
IN
Hi JocelynL,
You can check with below mentioned steps.
Perform the following local-change:
- Map a class to the database table using the external database class mapping wizard.
- Use Obj-Save instead of RDB-Save. Obj-Save stores the millisecond precision.
Flextronics Technology Co Ltd
CN
Hi Sonir,
Thanks for your reply!
I realized that it's my mistake which caused the seconds missing, actually the DateTime Util and DateTime Variable captured the datatime value with seconds correctly, but when I pass it to another process as an argument, I select string data type in the entry point, the seconds were missed from here, after I change the data type to DateTime in the entry point, it passes to SQL server correctly with seconds.
Again thanks for your kind suggestions.