Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread Sneha Bishnoi
Tried that..does not help :( On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal sagra...@idrcglobal.com wrote: Maybe converting POSIXct to character string using format before writing to csv will help. On 20 August 2014 17:23, Sneha Bishnoi sneha.bish...@gmail.com wrote: Hi All! This

Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread Jeff Newmiller
This problem is in Excel or your use thereof, not in R, and is therefore not technically on topic here. FWIW I am aware that localization of Excel can change the default date formats for input. I suspect that your installation of Excel has a different default date format than you are using in

Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread Duncan Mackay
Subject: Re: [R] DateTime wrong when exporting to csv in R Tried that..does not help :( On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal sagra...@idrcglobal.com wrote: Maybe converting POSIXct to character string using format before writing to csv will help. On 20 August 2014 17:23, Sneha

Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread Saurabh Agrawal
Maybe converting POSIXct to character string using format before writing to csv will help. On 20 August 2014 17:23, Sneha Bishnoi sneha.bish...@gmail.com wrote: Hi All! This seems to be trival but I am not able to find a solution for it. I have a dataframe with datetime columns in form of

Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread Saurabh Agrawal
Could you please post your code and some sample data? http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example On 20 August 2014 17:43, Sneha Bishnoi sneha.bish...@gmail.com wrote: Tried that..does not help :( On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal

Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread David Winsemius
On Aug 20, 2014, at 4:53 AM, Sneha Bishnoi wrote: Hi All! This seems to be trival but I am not able to find a solution for it. I have a dataframe with datetime columns in form of (%d/%m/%y %H:%M:%OS). I write it to csv file. Whne i open the csv file the date time format are in some

Re: [R] DateTime wrong when exporting to csv in R

2014-08-20 Thread David Winsemius
On Aug 20, 2014, at 1:48 PM, David Winsemius wrote: On Aug 20, 2014, at 4:53 AM, Sneha Bishnoi wrote: Hi All! This seems to be trival but I am not able to find a solution for it. I have a dataframe with datetime columns in form of (%d/%m/%y %H:%M:%OS). I write it to csv file. Whne