{"action":"created","issue":{"url":"https://api.github.com/repos/agershun/alasql/issues/461","repository_url":"https://api.github.com/repos/agershun/alasql","labels_url":"https://api.github.com/repos/agershun/alasql/issues/461/labels{/name}","comments_url":"https://api.github.com/repos/agershun/alasql/issues/461/comments","events_url":"https://api.github.com/repos/agershun/alasql/issues/461/events","html_url":"https://github.com/agershun/alasql/issues/461","id":117909693,"number":461,"title":"How to convert date string to my own date time format","user":{"login":"chaitujil","id":13523941,"avatar_url":"https://avatars.githubusercontent.com/u/13523941?v=3","gravatar_id":"","url":"https://api.github.com/users/chaitujil","html_url":"https://github.com/chaitujil","followers_url":"https://api.github.com/users/chaitujil/followers","following_url":"https://api.github.com/users/chaitujil/following{/other_user}","gists_url":"https://api.github.com/users/chaitujil/gists{/gist_id}","starred_url":"https://api.github.com/users/chaitujil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chaitujil/subscriptions","organizations_url":"https://api.github.com/users/chaitujil/orgs","repos_url":"https://api.github.com/users/chaitujil/repos","events_url":"https://api.github.com/users/chaitujil/events{/privacy}","received_events_url":"https://api.github.com/users/chaitujil/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/agershun/alasql/labels/!%20Question","name":"! Question","color":"fbca04"}],"state":"closed","locked":false,"assignee":{"login":"agershun","id":643040,"avatar_url":"https://avatars.githubusercontent.com/u/643040?v=3","gravatar_id":"","url":"https://api.github.com/users/agershun","html_url":"https://github.com/agershun","followers_url":"https://api.github.com/users/agershun/followers","following_url":"https://api.github.com/users/agershun/following{/other_user}","gists_url":"https://api.github.com/users/agershun/gists{/gist_id}","starred_url":"https://api.github.com/users/agershun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agershun/subscriptions","organizations_url":"https://api.github.com/users/agershun/orgs","repos_url":"https://api.github.com/users/agershun/repos","events_url":"https://api.github.com/users/agershun/events{/privacy}","received_events_url":"https://api.github.com/users/agershun/received_events","type":"User","site_admin":false},"assignees":[{"login":"agershun","id":643040,"avatar_url":"https://avatars.githubusercontent.com/u/643040?v=3","gravatar_id":"","url":"https://api.github.com/users/agershun","html_url":"https://github.com/agershun","followers_url":"https://api.github.com/users/agershun/followers","following_url":"https://api.github.com/users/agershun/following{/other_user}","gists_url":"https://api.github.com/users/agershun/gists{/gist_id}","starred_url":"https://api.github.com/users/agershun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agershun/subscriptions","organizations_url":"https://api.github.com/users/agershun/orgs","repos_url":"https://api.github.com/users/agershun/repos","events_url":"https://api.github.com/users/agershun/events{/privacy}","received_events_url":"https://api.github.com/users/agershun/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2015-11-19T21:17:01Z","updated_at":"2016-10-07T09:04:58Z","closed_at":"2015-11-20T15:56:49Z","body":"Hi, I am using this following way while doing an export to excel\r\n\r\nalasql.fn.Date = Date;\r\nalasql('SELECT new Date(mydateString) AS CUSTOM_DATE INTO XLS(\"' + filename + '.xls\",{headers:true}) FROM ?', [items]);\r\n\r\nThose above lines are printing in this below date format\r\nSat Jun 06 2015 00:00:00 GMT-0500 (Central Daylight Time)\r\n\r\nbut I want to format mydateString as \"MM-DD-YYYY hh:mm:ss\". How can I do that?"},"comment":{"url":"https://api.github.com/repos/agershun/alasql/issues/comments/252189282","html_url":"https://github.com/agershun/alasql/issues/461#issuecomment-252189282","issue_url":"https://api.github.com/repos/agershun/alasql/issues/461","id":252189282,"user":{"login":"rchawdhari","id":7466204,"avatar_url":"https://avatars.githubusercontent.com/u/7466204?v=3","gravatar_id":"","url":"https://api.github.com/users/rchawdhari","html_url":"https://github.com/rchawdhari","followers_url":"https://api.github.com/users/rchawdhari/followers","following_url":"https://api.github.com/users/rchawdhari/following{/other_user}","gists_url":"https://api.github.com/users/rchawdhari/gists{/gist_id}","starred_url":"https://api.github.com/users/rchawdhari/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rchawdhari/subscriptions","organizations_url":"https://api.github.com/users/rchawdhari/orgs","repos_url":"https://api.github.com/users/rchawdhari/repos","events_url":"https://api.github.com/users/rchawdhari/events{/privacy}","received_events_url":"https://api.github.com/users/rchawdhari/received_events","type":"User","site_admin":false},"created_at":"2016-10-07T09:04:58Z","updated_at":"2016-10-07T09:04:58Z","body":" I want to format mydateString as \"hh:mm:ss\". How can I do that?"}}
{"actor":{"display_login":"rchawdhari"}}