{"action":"closed","issue":{"url":"https://api.github.com/repos/tidyverse/readxl/issues/487","repository_url":"https://api.github.com/repos/tidyverse/readxl","labels_url":"https://api.github.com/repos/tidyverse/readxl/issues/487/labels{/name}","comments_url":"https://api.github.com/repos/tidyverse/readxl/issues/487/comments","events_url":"https://api.github.com/repos/tidyverse/readxl/issues/487/events","html_url":"https://github.com/tidyverse/readxl/issues/487","id":332205225,"node_id":"MDU6SXNzdWUzMzIyMDUyMjU=","number":487,"title":"Data Time format","user":{"login":"KS2907","id":40250313,"node_id":"MDQ6VXNlcjQwMjUwMzEz","avatar_url":"https://avatars1.githubusercontent.com/u/40250313?v=4","gravatar_id":"","url":"https://api.github.com/users/KS2907","html_url":"https://github.com/KS2907","followers_url":"https://api.github.com/users/KS2907/followers","following_url":"https://api.github.com/users/KS2907/following{/other_user}","gists_url":"https://api.github.com/users/KS2907/gists{/gist_id}","starred_url":"https://api.github.com/users/KS2907/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KS2907/subscriptions","organizations_url":"https://api.github.com/users/KS2907/orgs","repos_url":"https://api.github.com/users/KS2907/repos","events_url":"https://api.github.com/users/KS2907/events{/privacy}","received_events_url":"https://api.github.com/users/KS2907/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-06-13T23:55:35Z","updated_at":"2018-06-18T22:07:21Z","closed_at":"2018-06-18T22:07:21Z","author_association":"NONE","body":"I am trying to read a simple excel file with number of mixed type columns including two date columns, where the date stamp is in the following format\r\n```r\r\n2012-01-01 00:00:00\r\n```\r\nHowever the call to read_excel(filename) only result in reading the date part of the stamp as seen by \r\n\r\nInspecting the resulting data frame shows that it is being read in POSIXct format. \r\n\r\nViewing a field generates the following output:\r\n```r\r\n> df$`Estimated Arrival Date`[1]\r\n[1] \"2012-01-01 UTC\"\r\n```\r\nAnd when I write this data frame into another excel file using write_excel_csv(df, filename), I get the following weird format in the resulting excel file\r\n\r\n```r\r\n2013-01-01T00:00:00Z\r\n```\r\nHow do I read the data/time stamps in the same format and print it likewise?\r\n\r\nRegards\r\nKam"}}
{"actor":{"display_login":"KS2907"}}