{"action":"created","issue":{"url":"https://api.github.com/repos/Torndeco/extDB2/issues/22","labels_url":"https://api.github.com/repos/Torndeco/extDB2/issues/22/labels{/name}","comments_url":"https://api.github.com/repos/Torndeco/extDB2/issues/22/comments","events_url":"https://api.github.com/repos/Torndeco/extDB2/issues/22/events","html_url":"https://github.com/Torndeco/extDB2/issues/22","id":61898819,"number":22,"title":"DATETIME not (really) supported now?","user":{"login":"MrEichi","id":3540695,"avatar_url":"https://avatars.githubusercontent.com/u/3540695?v=3","gravatar_id":"","url":"https://api.github.com/users/MrEichi","html_url":"https://github.com/MrEichi","followers_url":"https://api.github.com/users/MrEichi/followers","following_url":"https://api.github.com/users/MrEichi/following{/other_user}","gists_url":"https://api.github.com/users/MrEichi/gists{/gist_id}","starred_url":"https://api.github.com/users/MrEichi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MrEichi/subscriptions","organizations_url":"https://api.github.com/users/MrEichi/orgs","repos_url":"https://api.github.com/users/MrEichi/repos","events_url":"https://api.github.com/users/MrEichi/events{/privacy}","received_events_url":"https://api.github.com/users/MrEichi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-15T20:59:11Z","updated_at":"2015-03-15T21:21:57Z","closed_at":null,"body":"Hey, I have fooled around with your extension and I really like it. However, I think I have found an issue. Once you SELECT a record that has a DATETIME column, it will fail when you compile the result. Code:\r\n\r\n_result = \"extDB2\" callExtension _query;\r\n_result = call compile format[\"%1\", _result];\r\n\r\nRPT says the following:\r\n\r\n21:51:37 Error in expression 0,100,100,1,0,0,0,0,0,0,0,0,0,2015-03-15T21:35:31Z,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"\r\n21:51:37   Error position: T21:35:31Z,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"\r\n21:51:37   Error Missing ]\r\n\r\nAs the textual representation of this DATETIME type contains your separator character \":\", I think it will be best to handle it as a string, thus wrapping it with quotes. I have tried doing so with the OUTPUT directive, but without any luck:\r\n\r\nOUTPUT = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19-STRING,20-STRING,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43\r\n\r\nPlease let me know if you need a beta tester. I am the lead developer of an upcoming ARMA III mod and I am willing to help you to get this bug-free :)"},"comment":{"url":"https://api.github.com/repos/Torndeco/extDB2/issues/comments/81245592","html_url":"https://github.com/Torndeco/extDB2/issues/22#issuecomment-81245592","issue_url":"https://api.github.com/repos/Torndeco/extDB2/issues/22","id":81245592,"user":{"login":"Torndeco","id":2651446,"avatar_url":"https://avatars.githubusercontent.com/u/2651446?v=3","gravatar_id":"","url":"https://api.github.com/users/Torndeco","html_url":"https://github.com/Torndeco","followers_url":"https://api.github.com/users/Torndeco/followers","following_url":"https://api.github.com/users/Torndeco/following{/other_user}","gists_url":"https://api.github.com/users/Torndeco/gists{/gist_id}","starred_url":"https://api.github.com/users/Torndeco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Torndeco/subscriptions","organizations_url":"https://api.github.com/users/Torndeco/orgs","repos_url":"https://api.github.com/users/Torndeco/repos","events_url":"https://api.github.com/users/Torndeco/events{/privacy}","received_events_url":"https://api.github.com/users/Torndeco/received_events","type":"User","site_admin":false},"created_at":"2015-03-15T21:21:57Z","updated_at":"2015-03-15T21:21:57Z","body":"The separator character will only effect INPUTS to extDB\r\n\r\nIt is possible to use OUTPUT Option to add string to DATETIME.\r\nKnown of one person that is using it, and is using SQF Code to convert T21:35:31Z into useable string.\r\n\r\nMore than likely you have the wrong OUTPUT Number having string, you got like 43 of them there :).\r\n\r\nIf you still having issues give me an example of Database Table + Query to Reproduce issue\r\n"}}