[R] DateTime wrong when exporting to csv in R

Sneha Bishnoi sneha.bishnoi at gmail.com
Wed Aug 20 13:53:41 CEST 2014


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 change it into date time
format, it gives me wrong value.

My data frame is as below:

 PostDate                            Status                 ArrTime
               NumGuests
 2014-08-14 16:13:08.850       O                    2012-01-13 00:00:00.000
     6
 2014-08-14 16:13:08.850       A


-SB

	[[alternative HTML version deleted]]



More information about the R-help mailing list