{"action":"created","issue":{"url":"https://api.github.com/repos/hangum/TadpoleForDBTools/issues/633","labels_url":"https://api.github.com/repos/hangum/TadpoleForDBTools/issues/633/labels{/name}","comments_url":"https://api.github.com/repos/hangum/TadpoleForDBTools/issues/633/comments","events_url":"https://api.github.com/repos/hangum/TadpoleForDBTools/issues/633/events","html_url":"https://github.com/hangum/TadpoleForDBTools/issues/633","id":109746917,"number":633,"title":"원도우에서 로그인 히스토리 정보 저장 오류","user":{"login":"hangum","id":1335915,"avatar_url":"https://avatars.githubusercontent.com/u/1335915?v=3","gravatar_id":"","url":"https://api.github.com/users/hangum","html_url":"https://github.com/hangum","followers_url":"https://api.github.com/users/hangum/followers","following_url":"https://api.github.com/users/hangum/following{/other_user}","gists_url":"https://api.github.com/users/hangum/gists{/gist_id}","starred_url":"https://api.github.com/users/hangum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hangum/subscriptions","organizations_url":"https://api.github.com/users/hangum/orgs","repos_url":"https://api.github.com/users/hangum/repos","events_url":"https://api.github.com/users/hangum/events{/privacy}","received_events_url":"https://api.github.com/users/hangum/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/hangum/TadpoleForDBTools/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"billygoo","id":2518075,"avatar_url":"https://avatars.githubusercontent.com/u/2518075?v=3","gravatar_id":"","url":"https://api.github.com/users/billygoo","html_url":"https://github.com/billygoo","followers_url":"https://api.github.com/users/billygoo/followers","following_url":"https://api.github.com/users/billygoo/following{/other_user}","gists_url":"https://api.github.com/users/billygoo/gists{/gist_id}","starred_url":"https://api.github.com/users/billygoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/billygoo/subscriptions","organizations_url":"https://api.github.com/users/billygoo/orgs","repos_url":"https://api.github.com/users/billygoo/repos","events_url":"https://api.github.com/users/billygoo/events{/privacy}","received_events_url":"https://api.github.com/users/billygoo/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/hangum/TadpoleForDBTools/milestones/12","html_url":"https://github.com/hangum/TadpoleForDBTools/milestones/1.6.5","labels_url":"https://api.github.com/repos/hangum/TadpoleForDBTools/milestones/12/labels","id":1315787,"number":12,"title":"1.6.5","description":"","creator":{"login":"hangum","id":1335915,"avatar_url":"https://avatars.githubusercontent.com/u/1335915?v=3","gravatar_id":"","url":"https://api.github.com/users/hangum","html_url":"https://github.com/hangum","followers_url":"https://api.github.com/users/hangum/followers","following_url":"https://api.github.com/users/hangum/following{/other_user}","gists_url":"https://api.github.com/users/hangum/gists{/gist_id}","starred_url":"https://api.github.com/users/hangum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hangum/subscriptions","organizations_url":"https://api.github.com/users/hangum/orgs","repos_url":"https://api.github.com/users/hangum/repos","events_url":"https://api.github.com/users/hangum/events{/privacy}","received_events_url":"https://api.github.com/users/hangum/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":13,"state":"closed","created_at":"2015-09-21T06:47:56Z","updated_at":"2015-10-12T12:18:53Z","due_on":null,"closed_at":"2015-10-10T18:48:49Z"},"comments":2,"created_at":"2015-10-05T07:56:01Z","updated_at":"2015-10-15T15:26:31Z","closed_at":null,"body":"로그인 히스토리 화면에서 로그인 시간이 1970-01-01으로 저장되는 오류가 있습니다. \r\nps) https://mail.google.com/mail/u/0/#inbox/15036b74cd27e013\r\n\r\n<img width=\"501\" alt=\"2015-10-05 4 54 54\" src=\"https://cloud.githubusercontent.com/assets/1335915/10275376/e171f59c-6b81-11e5-8908-e97e2c385a40.png\">\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/hangum/TadpoleForDBTools/issues/comments/148422009","html_url":"https://github.com/hangum/TadpoleForDBTools/issues/633#issuecomment-148422009","issue_url":"https://api.github.com/repos/hangum/TadpoleForDBTools/issues/633","id":148422009,"user":{"login":"billygoo","id":2518075,"avatar_url":"https://avatars.githubusercontent.com/u/2518075?v=3","gravatar_id":"","url":"https://api.github.com/users/billygoo","html_url":"https://github.com/billygoo","followers_url":"https://api.github.com/users/billygoo/followers","following_url":"https://api.github.com/users/billygoo/following{/other_user}","gists_url":"https://api.github.com/users/billygoo/gists{/gist_id}","starred_url":"https://api.github.com/users/billygoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/billygoo/subscriptions","organizations_url":"https://api.github.com/users/billygoo/orgs","repos_url":"https://api.github.com/users/billygoo/repos","events_url":"https://api.github.com/users/billygoo/events{/privacy}","received_events_url":"https://api.github.com/users/billygoo/received_events","type":"User","site_admin":false},"created_at":"2015-10-15T15:26:31Z","updated_at":"2015-10-15T15:26:31Z","body":"다른 브랜치를 가지고 고쳤네요. \r\n1.6.6 버전들어가면서 로그인 히스토리가 검색이 안되네요..;;;\r\n\r\n아래는 간단한 샘플이고, 지금 시간보다 큰 조건만 넣었을때 조회가 되고 특정일보다 작은 값을 넣으면 쿼리 결과가 조회가 안되네요.. 저만 그런걸까요?? \r\n\r\n위에 처럼 UserDAO 에서 Timestamp 타입을  String으로 처리하는걸 UserLoginHistoryDAO도 맞추려고 했는데 아래 오류가 나네요. \r\n\r\n로그인 기록 제대로 나오는지 확인 좀 해주시겠어요?? \r\n\r\n```sql\r\nSELECT\r\n    b.seq\r\n    ,b.user_seq\r\n    ,b.login_ip\r\n    ,b.connet_time\r\n    ,b.disconnect_time\r\n  FROM\r\n    tadpole_user a\r\n    ,login_history b\r\n  WHERE\r\n    a.email = 'sangmo.gu@gmail.com'\r\n    -- AND b.connet_time <= '1544316400056'\r\n    AND a.seq = b.user_seq\r\n    AND b.connet_time >= '1444316400056'\r\n  ORDER BY\r\n    b.connet_time DESC\r\n```"}}