[R] DateTime wrong when exporting to csv in R

Sneha Bishnoi sneha.bishnoi at gmail.com
Wed Aug 20 14:13:36 CEST 2014


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]]



More information about the R-help mailing list