michaelwittig / java-q Goto Github PK

This is an open question, but KDB doesn't support numeric types with defined precision (aka BigDecimal in Java or NUMBER (precision, scale) is Oracle.

That's why, Java retrieves "real" and "float" KDBs datatypes as Float and Double correspondingly.
Converting Float and Double to BigDecimal doesn't give any advantages, but:

1. Hides real type from end-user, which can sometimes lead to bugs. Especially when end-user would rounds incoming float/double values and convert them to BigDecimals with his own rules
2. Produces unnecessary BigDecimal objects.

It's up to you, but imho, using Float/Double types instead of BigDecimal will make API clearer.

• If you agree with this I can make appropriate change and send it to you for review.

Suppose I have a column of type DateTime and the values being
2017.09.06T21:39:39.831
2017.09.06T21:40:39.831

I want to filter datetime >'2017.09.06T21:39:39.831'. My query being below with fromDateObj =date Obj of '2017.09.06T21:39:39.831'
final Select select = tickTable.select().column(tickTable.time). .filter(tickTable.time.filterGreaterThan(DateTimeValue.from(fromDateObj))).build();

The above line gives me all the values.Looks like it has to be atleast a day difference to work.
In such a scenario it fails to give minute level difference.
Is there any way the filter can work for min/sec difference?