You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The format you use to insert into a DB (e.g. in fixtures) is different to what DBs return
The formats you can use to do a comparison like > or < is not consistent between SQLite and MySQL
The formats we return from the DB, and from our API endpoints can all be different
JSON comparisons seem to work in some cases and not others, but really we should be using ISODate
The mai use cases for dates are:
get helpers, where the real use case looks like this: {{#get "posts" filter="published_at:<='{{published_at}}'+id:-{{id}}" limit="3"}}
this means it depends what comes out of the API as to what goes back in...
ref: https://ghost.org/docs/themes/helpers/get/#filter
NQL date handling is in an unmanageable state.
We have to manage across the following variables:
{{#get "posts" filter="published_at:<='{{published_at}}'+id:-{{id}}" limit="3"}}this means it depends what comes out of the API as to what goes back in...
ref: https://ghost.org/docs/themes/helpers/get/#filter
ref: https://github.com/TryGhost/Ghost/blob/1cc38733ba6df8b8340420cff8fc7b643704c6ae/core/frontend/helpers/prev_post.js#L21
last_seen_at>now-1dref: Relative Dates #26
We need to make sure that dates work consistently in these 3 cases.