Hi can any one help me!!!
I need to display the latest entries by date and time ie i stored the date as 2009-Apr-16. so that i wrote a query as

select * from tbl_projectstatus order by date asc ,time  desc"

But the above code displays as follows ie Normaly i want to display as april first and then mar and then feb . But it displays april first and then feb and then march

2009-Apr-16         12:33:11            Hai i am good here
2009-Apr-16         12:32:10            Hai i am good here
2009-Apr-16         12:31:22            kjjkkj
2009-Feb-3          14:52:01            Good keep it Up
2009-Feb-3          14:37:12            How i s this
2009-Mar-18         10:41:52            I  the xxgyg project as on 
                                                        26.34.3455.    
2009-Mar-19         17:03:10            Hi iam prawin
2009-Mar-19         16:48:50            prawin kumar

Edited 3 Years Ago by mike_2000_17: Fixed formatting

Hi can any one help me!!!
I need to display the latest entries by date and time ie i stored the date as 2009-Apr-16. so that i wrote a query as

But the above code displays as follows ie Normaly i want to display as april first and then mar and then feb . But it displays april first and then feb and then march

2009-Apr-16         12:33:11            Hai i am good here
2009-Apr-16         12:32:10            Hai i am good here
2009-Apr-16         12:31:22            kjjkkj
2009-Feb-3          14:52:01            Good keep it Up
2009-Feb-3          14:37:12            How i s this
2009-Mar-18         10:41:52            I  the xxgyg project as on 
                                                        26.34.3455.    
2009-Mar-19         17:03:10            Hi iam prawin
2009-Mar-19         16:48:50            prawin kumar

end quote.

You are sorting the date alphabetically. Is it possible your field is TEXT, and not DATE?

Edited 3 Years Ago by mike_2000_17: Fixed formatting

This article has been dead for over six months. Start a new discussion instead.