R help - Oct 2007 - sort time

Hello, I have got the following problem:
  > times <- c("02.07.2007",
"03.07.2007","03.09.2007",
"04.07.2007","05.07.2007")
> mode(times)
[1] "numeric"
> tim <- as.character(times)
> mode(tim)
[1] "character"
  > sort(times)
[1] "02.07.2007" "03.07.2007" "03.09.2007"
"04.07.2007" "05.07.2007"

  Is it possible to get 
  > function(sort(times))
  [1] "02.07.2007" "03.07.2007" "04.07.2007"
"05.07.2007" "03.09.2007"
   
  Thank you very much in advance,
  Sam

   

       
---------------------------------

	[[alternative HTML version deleted]]

Samuel Okoye wrote:
> 
> Hello, I have got the following problem:
> [snip]
>  
> 
Assuming that these are in month/day/year format (which I conclude from
your sorted values):

times <- c("02.07.2007",
"03.07.2007","03.09.2007",
"04.07.2007","05.07.2007")
times2 <- as.Date(times,format="%m.%d.%Y")
sort(times2)

  Ben Bolker

-- 
View this message in context:
http://www.nabble.com/sort-time-tf4588604.html#a13098424
Sent from the R help mailing list archive at Nabble.com.

On Mon, 2007-10-08 at 07:26 -0700, Samuel Okoye wrote:
> Hello, I have got the following problem:
>   > times <- c("02.07.2007",
"03.07.2007","03.09.2007",
"04.07.2007","05.07.2007")
> > mode(times)
> [1] "numeric"
> > tim <- as.character(times)
> > mode(tim)
> [1] "character"
>   > sort(times)
> [1] "02.07.2007" "03.07.2007" "03.09.2007"
"04.07.2007" "05.07.2007"
> 
>   Is it possible to get 
>   > function(sort(times))
>   [1] "02.07.2007" "03.07.2007" "04.07.2007"
"05.07.2007" "03.09.2007"
>    
>   Thank you very much in advance,
>   Sam
You need to convert 'times' to a Date class object, which can be sorted
as dates and then re-formatted for output:
> format(sort(as.Date(times, format = "%d.%m.%Y")),
"%d.%m.%Y")
[1] "02.07.2007" "03.07.2007" "04.07.2007"
"05.07.2007" "03.09.2007"

Otherwise, you are sorting based upon a character vector, the order of
which will be locale dependent. Locale issues are likely why your
'times' object is initially a numeric vector and not a character
vector. 

You can of course encapsulate the above in a function.

See ?as.Date

HTH,

Marc Schwartz