query condition in Subtract 2 timestamps

Posted by Mamdouh Kaadan-2 on
URL: http://ofbiz.116.s1.nabble.com/query-condition-in-Subtract-2-timestamps-tp141298.html

Dear all

 

How can I make SQL query in OFBiz based on subtract 2 timestamps,

By example:

select * from table

where FIRST_ACTION_DATE- Second_ACTION_DATE <'+00 12:00:00.000000'

 

How can I make the previous statement using the delegator methods??

 

Thanks in advance

==================================

Mamdouh Kaadan

Software Engineer

IT - Application

Areeba SYRIA

Mobile: [phone]

Office :  [phone]   Ext: 2288

E-mail:[hidden email]