CURRENT_TIME format in esql

ibm-integration-bus extended-sql
Lee picture Lee · Feb 2, 2013 · Viewed 10.6k times · Source

What is the default format of the function CURRENT_TIME in esql and how do we change it as per our requirements(24 hr or 12 hr formats)

Answer

Richie picture Richie · Feb 7, 2013 
DECLARE castTime TIME;
SET castTime = CAST (timeValue AS TIME FORMAT timePattern)

where pattern can be

enter image description here

Related questions

How to cast(convert) string to blob? in ESQL?

So i am reading an XML file from request note of flow. And need to convert XML data to blob.

Read More
Websphere Message Broker: Accessing XML elements in ESQL

Websphere Message Broker: File in File out example. I have an XML file with repeating element structure. How can I access and modify value of a particular element in ESQL. I worte following code.. CREATE PROCEDURE CopyEntireMessage() BEGIN --SET OutputRoot = …

Read More
How to resolve WebSphere MQ Reason code 2195 related error?

I am getting an WebSphere MQ Reason code 2195 MQRC_UNEXPECTED_ERROR when I try to connect to the message flows deployed on the execution group. Can somebody please tell me what exactly does this reason code mean? Queue manager, broker , …

Read More