{"action":"created","issue":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-core/issues/641","repository_url":"https://api.github.com/repos/couchbase/couchbase-lite-core","labels_url":"https://api.github.com/repos/couchbase/couchbase-lite-core/issues/641/labels{/name}","comments_url":"https://api.github.com/repos/couchbase/couchbase-lite-core/issues/641/comments","events_url":"https://api.github.com/repos/couchbase/couchbase-lite-core/issues/641/events","html_url":"https://github.com/couchbase/couchbase-lite-core/issues/641","id":392298890,"node_id":"MDU6SXNzdWUzOTIyOTg4OTA=","number":641,"title":"STR_TO_MILLIS not returning null for invalid date(Feb 30th)","user":{"login":"jayahariv","id":10448770,"node_id":"MDQ6VXNlcjEwNDQ4Nzcw","avatar_url":"https://avatars2.githubusercontent.com/u/10448770?v=4","gravatar_id":"","url":"https://api.github.com/users/jayahariv","html_url":"https://github.com/jayahariv","followers_url":"https://api.github.com/users/jayahariv/followers","following_url":"https://api.github.com/users/jayahariv/following{/other_user}","gists_url":"https://api.github.com/users/jayahariv/gists{/gist_id}","starred_url":"https://api.github.com/users/jayahariv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jayahariv/subscriptions","organizations_url":"https://api.github.com/users/jayahariv/orgs","repos_url":"https://api.github.com/users/jayahariv/repos","events_url":"https://api.github.com/users/jayahariv/events{/privacy}","received_events_url":"https://api.github.com/users/jayahariv/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-12-18T19:22:36Z","updated_at":"2018-12-19T00:14:32Z","closed_at":"2018-12-19T00:13:46Z","author_association":"NONE","body":"N1QL: \r\n```\r\nSELECT STR_TO_MILLIS(\"2020-02-30T01:01:01Z\") as Milliseconds;\r\n\r\n{\r\n  \"results\": [\r\n    {\r\n      \"Milliseconds\": null\r\n    }\r\n  ]\r\n}\r\n\r\n```\r\n\r\nLiteCore: \r\n```\r\nresults: {\r\n    \"STR_TO_MILLIS()\" = 1583024461000; // Sunday, March 1, 2020 1:01:01 AM\r\n}\r\n```\r\n\r\nTested with 2018-12-32, and it is returning null. But this case is failing.\r\n\r\nIt's a leap year, hence Feb-30th. "},"comment":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-core/issues/comments/448420751","html_url":"https://github.com/couchbase/couchbase-lite-core/issues/641#issuecomment-448420751","issue_url":"https://api.github.com/repos/couchbase/couchbase-lite-core/issues/641","id":448420751,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0ODQyMDc1MQ==","user":{"login":"snej","id":43241,"node_id":"MDQ6VXNlcjQzMjQx","avatar_url":"https://avatars2.githubusercontent.com/u/43241?v=4","gravatar_id":"","url":"https://api.github.com/users/snej","html_url":"https://github.com/snej","followers_url":"https://api.github.com/users/snej/followers","following_url":"https://api.github.com/users/snej/following{/other_user}","gists_url":"https://api.github.com/users/snej/gists{/gist_id}","starred_url":"https://api.github.com/users/snej/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snej/subscriptions","organizations_url":"https://api.github.com/users/snej/orgs","repos_url":"https://api.github.com/users/snej/repos","events_url":"https://api.github.com/users/snej/events{/privacy}","received_events_url":"https://api.github.com/users/snej/received_events","type":"User","site_admin":false},"created_at":"2018-12-19T00:14:32Z","updated_at":"2018-12-19T00:14:32Z","author_association":"MEMBER","body":"The fix is leap-year-aware :-p"}}
{"actor":{"display_login":"snej"}}