Cannot get posts from the same date (SQLite3-specific?)
#23,441 opened on 2025/05/20
Repository metrics
- Stars
- (54,676 個のスター)
- PR merge metrics
- (平均マージ 19d 11h) (30d で 658 merged PRs)
説明
Issue Summary
In sqlite3, dates are formatted in the published_at column of the posts table as '2025-04-22 14:13:46'. (Note the space, lack of T, etc.) Using {{published_at}} in the theme gives you something like: 2025-04-22T10:13:46.000-04:00 So let's say I want posts newer and older than my current page's publication date.
Posts before: 2025-02-27T19:03:00.000-05:00 2025-02-13T19:02:00-05:00 2025-02-13T19:02:00-05:00 2025-02-13T19:02:00-05:00 2025-02-13T19:02:00-05:00 2025-02-13T19:02:00-05:00 2025-01-23T19:01:00-05:00 2025-01-23T19:01:00-05:00 2025-01-23T19:01:00-05:00 I'm getting the posts published at 2025-02-13T19:02:00-05:00 showing up as being after 2025-02-27T19:02:00-05:00 My guess here is that the filter is using the format the posts are in from the database. But there's no T in that date format, so everything from that date is after the published_at, because T > " "
Steps to Reproduce
see above
Ghost Version
5.116
Node.js Version
20
How did you install Ghost?
local install
Database type
SQLite3
Browser & OS version
No response
Relevant log / error output
Code of Conduct
- I agree to be friendly and polite to people in this repository