Originally posted by: vijji_WTX

Hi All,

Is there any way that we can acheive this in WTX instead of Oracle query.

if( time.hour < 10 ) then YES
else NO.

basic requirment is i have to trigger one function if time is between 10 clock to 12 clock midnight. if current time is 9 clock function/map card should send NO. if curent time is 10 clock function/map card should send YES.

I can do this using currenttime funciton but i have to convert it to TEXT and then to number and finally i have compare. Is there any easy way to do this.

Thanks in advance !!

regards

Vijji
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer

IF(FROMDATETIME(CURRENTDATETIME()"{HH24}")=10, "YES", "no")
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: vijji_WTX

Hi Repanzer,
Once againg thanks for your time and reply. I tested it and it is working. I just extended this as below..

= IF( TONUMBER(FROMDATETIME(CURRENTDATETIME(), "{HH24}")) <10 , 1, 0) // 1= proceed , 0=No proceed

Here i am using 3 functions....which is a performance issue ... Can u suggest we can fine tune this above condition..with same expected result....

Regards,
Vijji
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender