Tried that..does not help :(
On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal <sagra...@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.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. >> > > -- Sneha Bishnoi +14047235469 H. Milton Stewart School of Industrial & Systems Engineering Georgia Tech [[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.