MQSeries.net :: View topic - How to get the timestamp in hh:mm:ssss format in Trace Node

chris boehnke · Posted: Wed May 23, 2007 1:25 pm Post subject:

Hi guys,
I am recording the date and timestamp of a message by using a Trace Node with the statement:
Date is: ${EXTRACT(YEAR FROM CURRENT_DATE)}-${EXTRACT(MONTH FROM CURRENT_DATE)}-${EXTRACT (DAY FROM CURRENT_DATE)} Time is: ${EXTRACT(HOUR FROM CURRENT_TIMESTAMP)}:${EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)}:${CAST(CAST((1000*EXTRACT(SECOND FROM CURRENT_TIME)) AS INTEGER) AS CHAR)}

The timestamp is recording as eg: 9:9:59799. Is there anyway to standardize the timestamp as 09:09:59799(hh:mm:sssss) inside a Trace Node?.
I know that we use 'funcPadNumber' function to achieve this in a Compute Node. I dont know how we can do it in a Trace Node. Can we somehow implement this function in a Trace Node or do we have some other option to achieve this?.

Thanks.