{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/5550","repository_url":"https://api.github.com/repos/CartoDB/cartodb","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5550/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5550/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5550/events","html_url":"https://github.com/CartoDB/cartodb/issues/5550","id":106772514,"number":5550,"title":"BCE Dates","user":{"login":"gabriellehk","id":14313281,"avatar_url":"https://avatars.githubusercontent.com/u/14313281?v=3","gravatar_id":"","url":"https://api.github.com/users/gabriellehk","html_url":"https://github.com/gabriellehk","followers_url":"https://api.github.com/users/gabriellehk/followers","following_url":"https://api.github.com/users/gabriellehk/following{/other_user}","gists_url":"https://api.github.com/users/gabriellehk/gists{/gist_id}","starred_url":"https://api.github.com/users/gabriellehk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gabriellehk/subscriptions","organizations_url":"https://api.github.com/users/gabriellehk/orgs","repos_url":"https://api.github.com/users/gabriellehk/repos","events_url":"https://api.github.com/users/gabriellehk/events{/privacy}","received_events_url":"https://api.github.com/users/gabriellehk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2015-09-16T13:20:21Z","updated_at":"2016-11-16T16:26:29Z","closed_at":null,"body":"I am working on a mapping project which includes BCE dates, but I am having trouble getting CartoDB to understand them as dates. So far, the methods I have tried either give me a date in '69 or no date at all.\nOne way that the data has been inputted is with a format like -0050-11-02 (or 11/02/-50 etc.) to indicate November 2, 50 BCE. This results in \"null\" when the column is changed from string to date.\nAnother way that the data has been inputted is with a format like -0049, which results in a '69 date when the column is changed from string to date.\nAlternatively, if I try to input the data manually with the column already set to date, I have no option to input anything earlier than 1900.\n"},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/260993646","html_url":"https://github.com/CartoDB/cartodb/issues/5550#issuecomment-260993646","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5550","id":260993646,"user":{"login":"alonsogarciapablo","id":390398,"avatar_url":"https://avatars.githubusercontent.com/u/390398?v=3","gravatar_id":"","url":"https://api.github.com/users/alonsogarciapablo","html_url":"https://github.com/alonsogarciapablo","followers_url":"https://api.github.com/users/alonsogarciapablo/followers","following_url":"https://api.github.com/users/alonsogarciapablo/following{/other_user}","gists_url":"https://api.github.com/users/alonsogarciapablo/gists{/gist_id}","starred_url":"https://api.github.com/users/alonsogarciapablo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alonsogarciapablo/subscriptions","organizations_url":"https://api.github.com/users/alonsogarciapablo/orgs","repos_url":"https://api.github.com/users/alonsogarciapablo/repos","events_url":"https://api.github.com/users/alonsogarciapablo/events{/privacy}","received_events_url":"https://api.github.com/users/alonsogarciapablo/received_events","type":"User","site_admin":false},"created_at":"2016-11-16T16:26:29Z","updated_at":"2016-11-16T16:26:29Z","body":"There has been no activity on this issue for more several months. We are closing it. If you think this still needs to be addressed please open a new issue."}}
{"actor":{"display_login":"alonsogarciapablo"}}