Maybe converting POSIXct to character string using "format" before writing
to csv will help.
On 20 August 2014 17:23, Sneha Bishnoi <sneha.bish...@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@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]]
______________________________________________
R-help@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.
