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