作者:e絕纞乄 | 来源:互联网 | 2023-09-24 14:50
IhaveonedoubtinSqlite.dteTimeDataTypeisVarchar(200)inTablestructure.Iwanttogetresult
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 个解决方案