How do I can change timestamp format in defaultTrace.trc?

[Former Member]

hi every:

I want to change time fomat(ms-->yyyy-MM-dd hh:mm:ss.S) in defaultTrace.trc.somebody can tell me how to config it.thanks.

[Former Member · Accepted solution]

Hi,

Can you give me an example?

Regards,

Jai Shankar

[Former Member · Accepted solution]

eg:

#1.5#00096B6BE64C006A0004FA8F001480F4000422187F692E96#<b>[red]1163388519001[/red]</b>#com.sap.aii.adapter.jdbc.xml2sql#sap.com/com.sap.aii.af.app

-

---

>

#1.5#00096B6BE64C006A0004FA8F001480F4000422187F692E96#<b>[red]2006-12-24 00:00:00.000[/red]</b>#com.sap.aii.adapter.jdbc.xml2sql#sap.com/com.sap.aii.af.app

[Former Member · Accepted solution]

Use this code in your UDF. It takes one input(a)-> milliseconds in long

<b>long lngtime = Long.parseLong(a);

Date d = new Date(lngtime);

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.S");

return (sdf.format(d));</b>

Regards,

Jai Shankar