[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
 2014-08-14 16:13:08.850       O                    2012-01-13 00:00:00.000
 2014-08-14 16:13:08.850       A


	[[alternative HTML version deleted]]

More information about the R-help mailing list