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
ESQL : Check One of the incoming xml tag contains serialzed data

Need help to validate if one of the incoming XML tag contains serialized data or not. If ir doesn't contain then have to thow an user defined exception. This has to be achieved using ESQL. example : <input_data> &…

Read More