{"action":"created","issue":{"url":"https://api.github.com/repos/h2database/h2database/issues/150","labels_url":"https://api.github.com/repos/h2database/h2database/issues/150/labels{/name}","comments_url":"https://api.github.com/repos/h2database/h2database/issues/150/comments","events_url":"https://api.github.com/repos/h2database/h2database/issues/150/events","html_url":"https://github.com/h2database/h2database/pull/150","id":93124130,"number":150,"title":"Added Oracle compatible TO_DATE() and TO_TIMESTAMP() function.","user":{"login":"plus33","id":12482601,"avatar_url":"https://avatars.githubusercontent.com/u/12482601?v=3","gravatar_id":"","url":"https://api.github.com/users/plus33","html_url":"https://github.com/plus33","followers_url":"https://api.github.com/users/plus33/followers","following_url":"https://api.github.com/users/plus33/following{/other_user}","gists_url":"https://api.github.com/users/plus33/gists{/gist_id}","starred_url":"https://api.github.com/users/plus33/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plus33/subscriptions","organizations_url":"https://api.github.com/users/plus33/orgs","repos_url":"https://api.github.com/users/plus33/repos","events_url":"https://api.github.com/users/plus33/events{/privacy}","received_events_url":"https://api.github.com/users/plus33/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-07-05T16:24:42Z","updated_at":"2015-11-26T07:31:14Z","closed_at":"2015-09-24T07:03:20Z","pull_request":{"url":"https://api.github.com/repos/h2database/h2database/pulls/150","html_url":"https://github.com/h2database/h2database/pull/150","diff_url":"https://github.com/h2database/h2database/pull/150.diff","patch_url":"https://github.com/h2database/h2database/pull/150.patch"},"body":"2ed try. Should now only contain my changes and almost no auto formatting. \r\n\r\nAdded Oracle compatible TO_DATE() and TO_TIMESTAMP() function.\r\nThe 99% case is converted.\r\n\r\nThe good news is that it should be strait forward to extend the function\r\nand fix bugs.\r\n\r\nConsider this code in beta for corner cases as they are not well tested\r\nand due to the lake of an Oracle-Db I can't check how Oracle handles\r\nthese cases.\r\n\r\nCorner Cases:\r\n\r\n    TO_DATE where only a date fraction is given e.g. TO_DATE('46','WI') Time will show.\r\n    TimeZone (not tested)\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/h2database/h2database/issues/comments/159835065","html_url":"https://github.com/h2database/h2database/pull/150#issuecomment-159835065","issue_url":"https://api.github.com/repos/h2database/h2database/issues/150","id":159835065,"user":{"login":"plus33","id":12482601,"avatar_url":"https://avatars.githubusercontent.com/u/12482601?v=3","gravatar_id":"","url":"https://api.github.com/users/plus33","html_url":"https://github.com/plus33","followers_url":"https://api.github.com/users/plus33/followers","following_url":"https://api.github.com/users/plus33/following{/other_user}","gists_url":"https://api.github.com/users/plus33/gists{/gist_id}","starred_url":"https://api.github.com/users/plus33/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plus33/subscriptions","organizations_url":"https://api.github.com/users/plus33/orgs","repos_url":"https://api.github.com/users/plus33/repos","events_url":"https://api.github.com/users/plus33/events{/privacy}","received_events_url":"https://api.github.com/users/plus33/received_events","type":"User","site_admin":false},"created_at":"2015-11-26T07:31:14Z","updated_at":"2015-11-26T07:31:14Z","body":"As donator of the code this this question is mainly  my call I guess. Yes , you may. If you have any issues just contact me. \r\nNote: you may have to use a new error number as I used the last free number availalbe at that time and that may not be free any more. \r\nCheers Sam"}}