ORNL / DataFed

A Federated Scientific Data Management System
https://ornl.github.io/DataFed/
Other
18 stars 14 forks source link

System - Add support for regular date/time in search #415

Closed dvstans closed 3 years ago

dvstans commented 4 years ago

Dates are stored as timestamps in the database and there is no easy way for a user to specify a timestamp in a search query. Add a search function that would allow input of dates as strings, such as: date("2020-04-01 12:00"). The query parser would convert these to numeric timestamps for execution by the DB search code. (Also add support for relative times, like now - 10d)

dvstans commented 3 years ago

Closing - this issue should be dealt with by user agents (web portal, cli) not the core/db. The web portal already allows date input.