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

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

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 wrote: > Tried that..does not help :( > > > > On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal > wrote: > >> Mayb

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 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:%

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 wrote: > Maybe converting POSIXct to character string using "format" before writing > to csv will help. > > > > On 20 August 2014

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 Sneha Bishnoi
Tried that..does not help :( On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal wrote: > Maybe converting POSIXct to character string using "format" before writing > to csv will help. > > > > On 20 August 2014 17:23, Sneha Bishnoi wrote: > >> Hi All! >> >> This seems to be trival but I am not a

[R] DateTime wrong when exporting to csv in R

2014-08-20 Thread Sneha Bishnoi
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 number form . So even if I use custome settings from excel to