Hi , I have a site..where i need to list records based on the modified date...im storing the date in the table like this "2 July, 2009, 8:37 am"....and the query i write is "SELECT * FROM Table ORDER By profile_updated _date DESC"

profile_updated _field will have values similar to 2 July, 2009, 8:37 am....and the listed records order is not correct...the data type for this fields is varchar...what could be the issue..i...