I found fourjs fjs language -construct, it can not get correct sql conditon when i need use the ‘time’ condition.
look below, this is evidence:
g_wc = “rwb06=TO_DATE(‘2010-10-12 00:00:00′,’YYYY-MM-DD HH24:MI:SS’) and rwb07=TO_DATE(‘2010-10-19 00:00:00′,’YYYY-MM-DD HH24:MI:SS’) and rwb08 between ’11’ and ’12:13′ and rwb09 between ’14’ and ’15:16′ ”
g_wc2 = (null)
lc_qbe_sn = 0