CODEWITHSUNDEEP
dategraphnullgremlintinkerpop
Thirumal
Thirumal

Reputation: 9646

How to set the date as NULL or INFINITY in apache tinkerpop gremlin?

How to set the date as NULL or INFINITY in apache tinkerpop gremlin?

I have a field - start_date and end_date. end_date is optional and it's unknown. In a relational database, we can set either NULL or INFINITY.

Is there any recommended value?

Upvotes: 0

Views: 184

Answers (1)

Kelvin Lawrence
Kelvin Lawrence

Reputation: 14391

There is currently no way to store INFINITY or NULL. You have a few options.

  1. If working with epoch offsets perhaps use min-int -(2**63) or max-int (2**63)-1 as the definition for "no valid date set".
  2. If working with ISO 8601 datetime dates then perhaps choose a date that you are confident is beyond the scope of your applications lifetime and use that. Just remember to avoid repeating the Y2K problem :-) For example g.addV('event').property('endDate',datetime('9999-12-31'))

Upvotes: 1

Related Questions