Skip to content

Date differences when getting post_date with SQLite #52

Open
@swissspidy

Description

@swissspidy

In WP-CLI we noticed something that I beelieve is a bug in this plugin. Please correct me if I'm wrong though and this is supposed to be addressed at another level.

When we run wp post update 1234 --post_date='2005-01-24T09:52:00.000Z' --post_status='publish' --edit_date=1 and subsequently run wp post get 1234--field=post_date the output is different between MySQL and SQLite.

In MySQL:

$ wp post get 1234--field=post_date
2005-01-24 09:52:00

In SQLite with this plugin:

$ wp post get 1234--field=post_date
2005-01-24T09:52:00.000Z

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions