{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/20","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/20/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/20/events","html_url":"https://github.com/oracle/node-oracledb/issues/20","id":57577217,"number":20,"title":"Configurable DATE result type mapping","user":{"login":"hvrauhal","id":128113,"avatar_url":"https://avatars.githubusercontent.com/u/128113?v=3","gravatar_id":"","url":"https://api.github.com/users/hvrauhal","html_url":"https://github.com/hvrauhal","followers_url":"https://api.github.com/users/hvrauhal/followers","following_url":"https://api.github.com/users/hvrauhal/following{/other_user}","gists_url":"https://api.github.com/users/hvrauhal/gists{/gist_id}","starred_url":"https://api.github.com/users/hvrauhal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hvrauhal/subscriptions","organizations_url":"https://api.github.com/users/hvrauhal/orgs","repos_url":"https://api.github.com/users/hvrauhal/repos","events_url":"https://api.github.com/users/hvrauhal/events{/privacy}","received_events_url":"https://api.github.com/users/hvrauhal/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/oracle/node-oracledb/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"cjbj","id":200778,"avatar_url":"https://avatars.githubusercontent.com/u/200778?v=3","gravatar_id":"","url":"https://api.github.com/users/cjbj","html_url":"https://github.com/cjbj","followers_url":"https://api.github.com/users/cjbj/followers","following_url":"https://api.github.com/users/cjbj/following{/other_user}","gists_url":"https://api.github.com/users/cjbj/gists{/gist_id}","starred_url":"https://api.github.com/users/cjbj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjbj/subscriptions","organizations_url":"https://api.github.com/users/cjbj/orgs","repos_url":"https://api.github.com/users/cjbj/repos","events_url":"https://api.github.com/users/cjbj/events{/privacy}","received_events_url":"https://api.github.com/users/cjbj/received_events","type":"User","site_admin":false},"milestone":null,"comments":44,"created_at":"2015-02-13T09:31:43Z","updated_at":"2015-08-13T21:57:49Z","closed_at":null,"body":"[The current default Date mapping behaviour](https://github.com/oracle/node-oracledb/blob/master/doc/api.md#-result-type-mapping):\r\n\r\n> TIMESTAMP and DATE columns are fetched as TIMESTAMP WITH LOCAL TIMEZONE using OCIDateTime. \r\n\r\nis different from the default Date handling behaviour of the [Joe Ferner driver](https://github.com/joeferner/node-oracle#dates).\r\n\r\nI would like to disable mapping of Oracle `DATE`s to javascript dates completely, so that they would return `YYYY-MM-DD` strings which I could then convert myself.\r\n\r\nCustom type parsers like in the [node-postgres](https://github.com/brianc/node-pg-types) driver would also be nice."},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/130860762","html_url":"https://github.com/oracle/node-oracledb/issues/20#issuecomment-130860762","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/20","id":130860762,"user":{"login":"bjouhier","id":415044,"avatar_url":"https://avatars.githubusercontent.com/u/415044?v=3","gravatar_id":"","url":"https://api.github.com/users/bjouhier","html_url":"https://github.com/bjouhier","followers_url":"https://api.github.com/users/bjouhier/followers","following_url":"https://api.github.com/users/bjouhier/following{/other_user}","gists_url":"https://api.github.com/users/bjouhier/gists{/gist_id}","starred_url":"https://api.github.com/users/bjouhier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bjouhier/subscriptions","organizations_url":"https://api.github.com/users/bjouhier/orgs","repos_url":"https://api.github.com/users/bjouhier/repos","events_url":"https://api.github.com/users/bjouhier/events{/privacy}","received_events_url":"https://api.github.com/users/bjouhier/received_events","type":"User","site_admin":false},"created_at":"2015-08-13T21:57:49Z","updated_at":"2015-08-13T21:57:49Z","body":"@cjbj The timezone change is rather an academic argument for me. We are setting up all our connections in UTC. As we have our own pool (on top of the driver), we only need to set it when we grow the pool. \r\n\r\nQ: what happens if you execute an ALTER SESSION and then return the connection to the driver's pool? Will the next one who gets this connection from the pool get impacted? (again, academic question)."}}