title: Reading csv with date and time
body: <p>I am working in R and reading csv which has date and time in its first column. 
  I want to import this csv file in R first and then convert it to zoo obect. </p>
  
  <p>I am using the code in R</p>
  
  <pre><code>EURUSD &lt;- as.xts(read.zoo("myfile.csv",sep=",",tz="",header=T))
  </code></pre>
  
  <p>My csv file contain data in the format: </p>
  
  <pre><code>Date,Open,Low,High,Close
  2006-01-02 10:01:00,2822.9,2825.45,2822.1,2824.9
  2006-01-02 10:02:00,2825,2825.9,2824,2824.95
  2006-01-02 10:03:00,2824.55,2826.45,2824,2826.45
  2006-01-02 10:04:00,2826.45,2826.45,2824.9,2825.5
  2006-01-02 10:05:00,2825.15,2825.5,2824,2824.85
  2006-01-02 10:06:00,2824.7,2825.5,2823.7,2823.8
  2006-01-02 10:07:00,2823.95,2824.45,2823.55,2824
  2006-01-02 10:08:00,2824,2824.85,2823.5,2824.85
  2006-01-02 10:09:00,2824.25,2825.45,2824,2825.45
  2006-01-02 10:10:00,2825.2,2827,2825,2827
  </code></pre>
  
  <p>When I run the above command to import the data in to R I get the folowwwing error : </p>
  
  <pre><code>Error in as.POSIXlt.character(x, tz, ...) : 
    character string is not in a standard unambiguous format
  </code></pre>
  
  <p>I tried to find all the ways to sort out the issue. I read so many blogs over net but none of the method works for me. </p>
  
  <p>I hope someone would help me. </p>