[R] Time and Date formatting

[Ayyappa Chaturvedula]

That works for me and thanks for the help.


On Apr 23, 2013, at 2:59 PM, Rui Barradas <ruipbarradas at sapo.pt> wrote:

> Hello,
> 
> Forgot to add strptime, like you had noted.
> 
> strptime(paste(DATE, TIME), format = "%d/%m/%Y %H:%M")
> 
> 
> Rui Barradas
> 
> Em 23-04-2013 19:54, Rui Barradas escreveu:
>> Hello,
>> 
>> See if any of the following will do.
>> 
>> 
>> DATE <- "14/07/2010"
>> TIME <-  "20:21"
>> paste(DATE, TIME)
>> as.POSIXct(paste(DATE, TIME), format = "%d/%m/%Y %H:%M")
>> 
>> 
>> Hope this helps,
>> 
>> Rui Barradas
>> 
>> Em 23-04-2013 19:46, Ayyappa Chaturvedula escreveu:
>>> Dear Group,
>>> 
>>> I have  a problem with time date formatting.  I have Date and Time in
>>> different columns in a .csv file and want to have a column with Date and
>>> Time together.  I could format the date into the right mode using
>>> strptime
>>> and as.Date functions.  I am not able to do that with TIME column. I
>>> appreciate your help in solving this issue.  Currently the TIME column is
>>> in character mode.
>>> 
>>> 
>>>   DATE              TIME                   DATETIME
>>> 14/07/2010       20:21    *Want:* 14/07/2010  20:11
>>> 
>>> Thanks in advance for your help.
>>> 
>>> Regards,
>>> Ayyappa
>>> 
>>>    [[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.
>> 
>> ______________________________________________
>> 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.