在SQLiteOrderByDatetime中，desc返回错误的数据-InSQLiteOrderByDatetimedescreturningwrongdata

I have one doubt in Sqlite.dteTime DataType is Varchar(200) in Table structure. I want to get result in order by Date Time.

我在Sqlite.dteTime中有一个疑问DataType是Table结构中的Varchar(200)。我希望按日期时间顺序获得结果。

"select dteTime from table ORDER BY dteTime Desc",

“从表ORDER BY dteTime Desc中选择dteTime”,

getting result is

得到的结果是

"05/05/2015 12:38:43 PM"

“05/05/2015 12:38:43 PM”

"05/05/2015 12:38:43 AM"

“05/05/2015 12:38:43 AM”

"05/05/2015 10:57:04 AM"

“05/05/2015 10:57:04 AM”

"05/05/2015 10:57:04 AM"

“05/05/2015 10:57:04 AM”

"05/05/2015 10:51:25 AM"

“05/05/2015 10:51:25 AM”

"05/05/2015 10:51:25 AM"

“05/05/2015 10:51:25 AM”

"05/05/2015 04:38:35 PM"

“05/05/2015 04:38:35 PM”

"05/05/2015 04:00:48 PM"

“05/05/2015 04:00:48 PM”

"05/04/2015 11:38:43 PM"

“05/04/2015 11:38:43 PM”

Instead of this how can i get(Expected Result)

而不是这个我怎么能得到(预期结果)

"05/05/2015 04:38:35 PM"

“05/05/2015 04:38:35 PM”

"05/05/2015 04:00:48 PM"

“05/05/2015 04:00:48 PM”

"05/05/2015 12:38:43 PM"

“05/05/2015 12:38:43 PM”

"05/05/2015 10:57:04 AM"

“05/05/2015 10:57:04 AM”

"05/05/2015 10:57:04 AM"

“05/05/2015 10:57:04 AM”

"05/05/2015 10:51:25 AM"

“05/05/2015 10:51:25 AM”

"05/05/2015 10:51:25 AM"

“05/05/2015 10:51:25 AM”

"05/05/2015 12:38:43 AM"

“05/05/2015 12:38:43 AM”

"05/04/2015 11:38:43 PM"

“05/04/2015 11:38:43 PM”

Any solution?

2 个解决方案