How to pass time value in Select query where condition?

Posted by ithrees on 23-Jul-2015 00:48

Hi All,

Is it the only way to pass time value in a where condition of a select query by converting it to millisecond? or is there any other way pass it in a user friendly format such time='19:30' or time='7:30PM' instead of time='70200000'?

Thanks in advance,
Ithrees

Rollbase - Forum

Posted by satyanarayana sunku on 23-Jul-2015 07:37

Hi,

Output of Time Field for selectQuery returns in milli seconds. So we can pass only milliseconds to retrive the data from where clause.

Thanks

Satya

All Replies

Posted by satyanarayana sunku on 23-Jul-2015 07:37

Hi,

Output of Time Field for selectQuery returns in milli seconds. So we can pass only milliseconds to retrive the data from where clause.

Thanks

Satya

This thread is closed