How to express current date in MQL Freebase Query?

Question

Freebase's metaweb query language can be used to retreive future events if you pass in an ISO8601 formatted date.

[{
  "id":            null,
  "name":          null,
  "start_date" :   null,
  "type":          "/time/event",
  "start_date>" :  "2011-09-02"
}]

^ run this query

Does MQL support an equivalent to SQL's `NOW()` or `CURDATE()`?

score 4 · Accepted Answer · edited Dec 05 '13 at 16:21

4

You can also use __now__ in timestamp fields as a special shortcut:

[{
  "id":            null,
  "name":          null,
  "start_date" :   null,
  "type":          "/time/event",
  "start_date>" :  "__now__"
}]

You can see a live demo of this via this Freebase Query Editor snippet.

edited Dec 05 '13 at 16:21

Günter Zöchbauer

623,577
216
2,003
1,567

answered Nov 03 '11 at 16:18

Michael Masouras

511
2
3

Nice! I didn't know that existed. – Shawn Simister Nov 03 '11 at 18:18

score 1 · Answer 2 · edited Dec 05 '13 at 16:21

There is no equivalent to SQL's NOW() or CURDATE in MQL. Whichever programming language you're using to send the query should have an equivalent function which you can use.

You can kind of get a list of future events by sorting them in descending order of start_date like this:

[{
  "id":         null,
  "name":       null,
  "type":       "/time/event",
  "start_date": {
    "value":    null,
    "optional": false
  },
  "sort":       "-start_date.value"
}]

How to express current date in MQL Freebase Query?

Does MQL support an equivalent to SQL's NOW() or CURDATE()?

2 Answers2

Does MQL support an equivalent to SQL's `NOW()` or `CURDATE()`?