org-sql
org-sql copied to clipboard
Timestamps as property values don't land in timestamps table
Another day, another feature I'd like to have: Timestamps can be used in/as property values, like in
* Example
:PROPERTIES:
:EXAMPLE_TIMESTAMP: [2024-08-14 Wed 07:15]
:END:
If I implement this, my first idea would be to, in addition to parsing the timestamp and adding it to the timestamps table, add a property_timestamps
table, inspired by headline_properties
, since this is how org-sql
tracks one-to-many relationships from what I can tell.
As always, I'd appreciate thoughts on this.
As an aside, I found a Reddit post where somebody started to catalogue places where one can use timestamps in Org Mode, and what difference the place makes to how the timestamp is interpreted.