{"action":"created","issue":{"url":"https://api.github.com/repos/go-goracle/goracle/issues/121","repository_url":"https://api.github.com/repos/go-goracle/goracle","labels_url":"https://api.github.com/repos/go-goracle/goracle/issues/121/labels{/name}","comments_url":"https://api.github.com/repos/go-goracle/goracle/issues/121/comments","events_url":"https://api.github.com/repos/go-goracle/goracle/issues/121/events","html_url":"https://github.com/go-goracle/goracle/issues/121","id":379923385,"node_id":"MDU6SXNzdWUzNzk5MjMzODU=","number":121,"title":"Inserting a timestamp value loses the fractional second","user":{"login":"ravikumars","id":1864888,"node_id":"MDQ6VXNlcjE4NjQ4ODg=","avatar_url":"https://avatars0.githubusercontent.com/u/1864888?v=4","gravatar_id":"","url":"https://api.github.com/users/ravikumars","html_url":"https://github.com/ravikumars","followers_url":"https://api.github.com/users/ravikumars/followers","following_url":"https://api.github.com/users/ravikumars/following{/other_user}","gists_url":"https://api.github.com/users/ravikumars/gists{/gist_id}","starred_url":"https://api.github.com/users/ravikumars/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ravikumars/subscriptions","organizations_url":"https://api.github.com/users/ravikumars/orgs","repos_url":"https://api.github.com/users/ravikumars/repos","events_url":"https://api.github.com/users/ravikumars/events{/privacy}","received_events_url":"https://api.github.com/users/ravikumars/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-12T19:39:01Z","updated_at":"2018-11-13T19:10:26Z","closed_at":null,"author_association":"NONE","body":"I am inserting a timestamp value into an oracle database with Column as TIMESTAMP(6). \r\ne.g.\r\n`SRB_RECEIVE_DATE := time.Now();  \r\nstmt, err := db.Prepare(\"INSERT INTO {table}(srb_receive_date) values(:1)\");  \r\nstm.Exec(SRB_RECEIVE_DATE)`\r\n\r\nThe record is inserted but the fractional part is all zeroes\r\n![image](https://user-images.githubusercontent.com/1864888/48370930-8a98a380-e688-11e8-86a0-fe2387f3e8ce.png)\r\n\r\nThe SRB_RECEIVE_DATE itself has the nanosecond part.\r\n\r\nAny idea why?"},"comment":{"url":"https://api.github.com/repos/go-goracle/goracle/issues/comments/438398496","html_url":"https://github.com/go-goracle/goracle/issues/121#issuecomment-438398496","issue_url":"https://api.github.com/repos/go-goracle/goracle/issues/121","id":438398496,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODM5ODQ5Ng==","user":{"login":"ravikumars","id":1864888,"node_id":"MDQ6VXNlcjE4NjQ4ODg=","avatar_url":"https://avatars0.githubusercontent.com/u/1864888?v=4","gravatar_id":"","url":"https://api.github.com/users/ravikumars","html_url":"https://github.com/ravikumars","followers_url":"https://api.github.com/users/ravikumars/followers","following_url":"https://api.github.com/users/ravikumars/following{/other_user}","gists_url":"https://api.github.com/users/ravikumars/gists{/gist_id}","starred_url":"https://api.github.com/users/ravikumars/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ravikumars/subscriptions","organizations_url":"https://api.github.com/users/ravikumars/orgs","repos_url":"https://api.github.com/users/ravikumars/repos","events_url":"https://api.github.com/users/ravikumars/events{/privacy}","received_events_url":"https://api.github.com/users/ravikumars/received_events","type":"User","site_admin":false},"created_at":"2018-11-13T19:10:26Z","updated_at":"2018-11-13T19:10:26Z","author_association":"NONE","body":"Thanks for the update. I am using the timestamp formatted to string and passing on to be inserted. \r\ne.g.\r\n`SRB_RECEIVE_DATE = time.Now().Format(\"2-Jan-06 3:04:05.000000 PM\")`\r\n\r\nWorks as expected."}}
{"actor":{"display_login":"ravikumars"}}