SQLite comp subscriptions deleted when not expired

[cathysarisky]

Issue Summary

Discussion here: https://forum.ghost.org/t/bulk-creation-of-comped-users-via-admin-api-expiration-issue-after-approx-15-hours/55244/7

clean-expired-comped deletes complimentary subscriptions that are not expired, but only when running in development. The problem appears to be a difference in date formatting for expiry_date in members_products

Steps to Reproduce

Install Ghost with sqlite. I'm using the source/development install.
Change the job schedule to every minute, or you'll be bored.
Create some complimentary members. Wait a minute for them to be converted to free.

Ghost Version

5.109

Node.js Version

20

How did you install Ghost?

source install.

Database type

MySQL 8

Browser & OS version

No response

Relevant log / error output

Code of Conduct

• I agree to be friendly and polite to people in this repository