title: Date time in write.csv in R
body: <p>I am having data frame named "data" with following column</p>
  
  <pre><code>&gt;  2007-01-02 10:02:00
     2007-01-02 10:03:00
     2007-01-02 10:04:00
     2007-01-02 10:05:00
     2007-01-02 10:06:00
     2007-01-02 10:07:00
  </code></pre>
  
  <p>When I save data using write.csv(data,"Data.csv",row.names=F)  and csv open like</p>
  
  <pre><code>&gt;  Column1            Column2
    2007-01-02    10:02:00
    2007-01-02    10:03:00
    2007-01-02    10:04:00
    2007-01-02    10:05:00
    2007-01-02    10:06:00
    2007-01-02    10:07:00
  </code></pre>
  
  <p>When I import the data in R again using read.csv("Data.csv"). It shows exact data format. </p>
  
  <pre><code>&gt;  2007-01-02 10:02:00
     2007-01-02 10:03:00
     2007-01-02 10:04:00
     2007-01-02 10:05:00
     2007-01-02 10:06:00
     2007-01-02 10:07:00
  </code></pre>
  
  <p>I have no idea how come excel shows date and time in 2 separate columns while the datetime column in actually 1 column. How can I get the datetime in 1 column in csv format? </p>