sql query

Question

prawin@123 0 Light Poster

15 Years Ago

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

php

Edited 11 Years Ago by mike_2000_17 because: Fixed formatting

2 Contributors
1 Reply
101 Views
9 Hours Discussion Span
Latest Post 15 Years Ago Latest Post by rikcando

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

rikcando 0 Newbie Poster · Answer 1 · 2009-04-21T19:41:35+00:00

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?