How to filer by date type property?

[ZhiqinYang]

Janusgraph version : 0.5.1
Query:

g.V().has("__uid__","196dd4490fa6ee88209178a0d02b034c").bothE().otherV().has("update_time",gt("2019-05-11T19:18:08+00:00")).valueMap()

I run such query , logs show like this :

2021-05-11 11:08:33 WARN  org.apache.tinkerpop.gremlin.server.op.AbstractEvalOpProcessor  - Exception processing a script on request [RequestMessage{, requestId=61c12d76-d89b-4d0b-9537-236555d71bfb, op='eval', processor='session', args={gremlin= ConfiguredGraphFactory.open("84be6954").traversal().V().has("__uid__","196dd4490fa6ee88209178a0d02b034c").bothE().otherV().hasLabel("transfer").has("update_time",gt("2019-05-11T19:18:08+00:00")).valueMap(), session=78d9d421-8393-45b5-8e8e-a2141dfaa5ea, manageTransaction=false, userAgent=Gremlin Console/3.4.6, batchSize=64}}].
java.lang.IllegalArgumentException: Cannot compare 'Wed Nov 07 01:19:25 CST 2018' (Date) and '2019-05-11T19:18:08+00:00' (String) as both need to be an instance of Number or Comparable (and of the same type)
	at org.apache.tinkerpop.gremlin.process.traversal.Compare.throwException(Compare.java:193)
	at org.apache.tinkerpop.gremlin.process.traversal.Compare.access$300(Compare.java:34)
	at org.apache.tinkerpop.gremlin.process.traversal.Compare$3.test(Compare.java:96)
	at org.apache.tinkerpop.gremlin.process.traversal.P.test(P.java:72)
	at org.apache.tinkerpop.gremlin.process.traversal.step.util.HasContainer.testValue(HasContainer.java:115)
	at org.apache.tinkerpop.gremlin.process.traversal.step.util.HasContainer.test(HasContainer.java:86)
	at org.apache.tinkerpop.gremlin.process.traversal.step.util.HasContainer.testAll(HasContainer.java:181)
	at org.apache.tinkerpop.gremlin.process.traversal.step.filter.HasStep.filter(HasStep.java:50)
	at org.apache.tinkerpop.gremlin.process.traversal.step.filter.FilterStep.processNextStart(FilterStep.java:38)
	at org.apache.tinkerpop.gremlin.process.traversal.step.util.AbstractStep.hasNext(AbstractStep.java:143)
	at org.apache.tinkerpop.gremlin.process.traversal.step.util.ExpandableStepIterator.next(ExpandableStepIterator.java:50)
	at org.apache.tinkerpop.gremlin.process.traversal.step.map.MapStep.processNextStart(MapStep.java:36)
	at org.apache.tinkerpop.gremlin.process.traversal.step.util.AbstractStep.hasNext(AbstractStep.java:143)
	at org.apache.tinkerpop.gremlin.process.traversal.util.DefaultTraversal.hasNext(DefaultTraversal.java:197)
	at org.apache.tinkerpop.gremlin.server.op.AbstractOpProcessor.handleIterator(AbstractOpProcessor.java:93)
	at org.apache.tinkerpop.gremlin.server.op.AbstractEvalOpProcessor.lambda$evalOpInternal$5(AbstractEvalOpProcessor.java:264)
	at org.apache.tinkerpop.gremlin.groovy.engine.GremlinExecutor.lambda$eval$0(GremlinExecutor.java:278)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
5/11/21 11:09:43 AM ============================================================

Schema with property ：

update_time                    | SINGLE      | class java.util.Date

How to get correct result with date filter?

But when i run follow query , result is correct !

g.V().has("__uid__","196dd4490fa6ee88209178a0d02b034c").has("update_time",gt("2019-05-11T19:18:08+00:00")).valueMap()

What different with both ?

[li-boxuan]

Seems to be a bug as reported at #1254

Can you try using a Date object, rather than a String value?

[ZhiqinYang]

Thanks , I have change to Date , it works !