[R] Request

[Ghosh Mini]

Dear all,

I am calling a table (data of several years) by psql command (order by
date)

aggregate(mydata[, c("nymphs", "adults")],list(date = mydata$date)

is giving table order by month (of each year) like


1 09-29-1999 0.00000000 0.00000000
2 09-30-1999 0.16666667 0.00000000
3 10-05-2000 0.55555556 0.05555556
4 11-04-2000 0.07142857 0.00000000
5 11-05-2000 0.55000000 0.05000000
6 12-08-1999 0.00000000 0.00000000
7 12-09-2000 0.56410256 0.00000000

I want it arranged by date (increasing order).

If possible pl. help me, thanking you.

regards,
mini