{"action":"created","issue":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/823","repository_url":"https://api.github.com/repos/Raizlabs/DBFlow","labels_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/823/labels{/name}","comments_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/823/comments","events_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/823/events","html_url":"https://github.com/Raizlabs/DBFlow/issues/823","id":156473838,"number":823,"title":"comparing formatted dates","user":{"login":"maestr0ua","id":11719504,"avatar_url":"https://avatars.githubusercontent.com/u/11719504?v=3","gravatar_id":"","url":"https://api.github.com/users/maestr0ua","html_url":"https://github.com/maestr0ua","followers_url":"https://api.github.com/users/maestr0ua/followers","following_url":"https://api.github.com/users/maestr0ua/following{/other_user}","gists_url":"https://api.github.com/users/maestr0ua/gists{/gist_id}","starred_url":"https://api.github.com/users/maestr0ua/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maestr0ua/subscriptions","organizations_url":"https://api.github.com/users/maestr0ua/orgs","repos_url":"https://api.github.com/users/maestr0ua/repos","events_url":"https://api.github.com/users/maestr0ua/events{/privacy}","received_events_url":"https://api.github.com/users/maestr0ua/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-24T10:31:31Z","updated_at":"2016-05-24T19:13:46Z","closed_at":null,"body":"DBFlow Version:3.0.0-beta6\r\nIssue Kind (Bug, Question, Feature):Question\r\n\r\nDescription: How can I make query for comparing two dates as string parameter?\r\nThis is how a I`m trying, but this is not working\r\n```\r\n@Table(database = ***.class)\r\npublic class InStoreTable extends BaseModel {\r\n\r\n    @PrimaryKey\r\n    String _id;\r\n\r\n    @Column\r\n    String creationDate;\r\n}\r\n\r\nSQLite.select()\r\n         .from(InStoreTable.class)\r\n         .where(InStoreTable_Table.creationDate.greaterThanOrEq(\"strftime('%Y-%m-%dT%H:%M:%S.%f', '2016-05-01T10:22:50.878Z')\"));\r\n```"},"comment":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/comments/221373606","html_url":"https://github.com/Raizlabs/DBFlow/issues/823#issuecomment-221373606","issue_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/823","id":221373606,"user":{"login":"maestr0ua","id":11719504,"avatar_url":"https://avatars.githubusercontent.com/u/11719504?v=3","gravatar_id":"","url":"https://api.github.com/users/maestr0ua","html_url":"https://github.com/maestr0ua","followers_url":"https://api.github.com/users/maestr0ua/followers","following_url":"https://api.github.com/users/maestr0ua/following{/other_user}","gists_url":"https://api.github.com/users/maestr0ua/gists{/gist_id}","starred_url":"https://api.github.com/users/maestr0ua/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maestr0ua/subscriptions","organizations_url":"https://api.github.com/users/maestr0ua/orgs","repos_url":"https://api.github.com/users/maestr0ua/repos","events_url":"https://api.github.com/users/maestr0ua/events{/privacy}","received_events_url":"https://api.github.com/users/maestr0ua/received_events","type":"User","site_admin":false},"created_at":"2016-05-24T19:13:46Z","updated_at":"2016-05-24T19:13:46Z","body":"and the second question. How can I format Property (in my case - InStoreTable_Table.creationDate)? I want to make something like this:\r\n\r\nSELECT * FROM InStoreTable WHERE strftime('''%Y-%m-%d', creationDate)>='strftime('%Y-%m-%d', 2016-05-01T18:48:17.329Z)'"}}
{"actor":{"display_login":"maestr0ua"}}