DateTime wrong when exporting to csv in R
Hi If you really need to have minutes and seconds etc in excel then use a package that can write datetime columns that excel can read eg. access rather that csv. Microsoft is well known for changing dates and date formats - remember excel is a worksheet application not a database - caveat emptor. If you use a formatted date that excel can recognize then excel has less of a tendency to change it. Datetime is a pain in any language because of the irregularity of time. Beware MS does not get it right if you are using dates from ca 1890 to 1910 Duncan Duncan Mackay Department of Agronomy and Soil Science University of New England Armidale NSW 2351 Email: home: mackay at northnet.com.au -----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Sneha Bishnoi Sent: Wednesday, 20 August 2014 22:14 To: Saurabh Agrawal Cc: r-help Subject: Re: [R] DateTime wrong when exporting to csv in R 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 [[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.