DBAL-710: [GH-449] Document possible Sqlite datetime issues. #1934

doctrinebot opened this Issue Dec 17, 2013 · 2 comments

2 participants


Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of bantu:

Url: #449


This may also be considered a bug instead.

SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table tbl1(dt datetime);
sqlite> insert into tbl1 (dt) VALUES ('2013-05-20 00:56');
sqlite> insert into tbl1 (dt) VALUES ('foo');
sqlite> select * from tbl1;
2013-05-20 00:56
sqlite> select datetime(dt) from tbl1;
2013-05-20 00:56:00


Discovered via owncloud/core#6327
Refs owncloud/core@f8088ec


Comment created by @doctrinebot:

A related Github Pull-Request [GH-449] was closed:


Issue was closed with resolution "Fixed"

@beberlei beberlei was assigned by doctrinebot Dec 7, 2015
@doctrinebot doctrinebot added this to the 2.5 milestone Dec 7, 2015
@doctrinebot doctrinebot closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment