[R] DateTime wrong when exporting to csv in R
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>
> 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
>> 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
>> 2014-08-14 16:13:08.850 O 2012-01-13
>> 2014-08-14 16:13:08.850 A
>> [[alternative HTML version deleted]]
>> R-help at r-project.org mailing list
>> PLEASE do read the posting guide
>> and provide commented, minimal, self-contained, reproducible code.
H. Milton Stewart School of Industrial & Systems Engineering
[[alternative HTML version deleted]]
More information about the R-help