DateTime wrong when exporting to csv in R
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.bishnoi at gmail.com> wrote:
Tried that..does not help :( On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal <sagrawal at 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.bishnoi at 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 ("%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]]
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
-- Sneha Bishnoi +14047235469 H. Milton Stewart School of Industrial & Systems Engineering Georgia Tech