[R] DateTime wrong when exporting to csv in R

[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.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.
>

	[[alternative HTML version deleted]]