[R] DateTime wrong when exporting to csv in R

Saurabh Agrawal sagrawal at idrcglobal.com
Wed Aug 20 14:20:36 CEST 2014


Could you please post your code and some sample data?

http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example



On 20 August 2014 17:43, Sneha Bishnoi <sneha.bishnoi at gmail.com> wrote:

> 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