The CURRENT_TIMESTAMP datetime function returns the current date and local time.
CURRENT_TIMESTAMP returns a TIMESTAMP value representing the current date and local time. As with all SQL functions that take no parameters, no parentheses are required or accepted. All calls to CURRENT_TIMESTAMP within the processing of one node are guaranteed to return the same value.
<Body> <Message>Hello World</Message> <DateStamp>2006-02-01 13:13:56.444730</DateStamp> </Body>use the following ESQL:
SET OutputRoot.XMLNS.Body.Message = 'Hello World'; SET OutputRoot.XMLNS.Body.DateStamp = CURRENT_TIMESTAMP;