select截断

错误:

sql = "select title,url,datetime(last_visit_time)/1000000-11644473600,'unixepoch','localtime') from urls order by last_visit_time desc;";

 

正确:

sql = "select title,url,datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime') from urls order by last_visit_time desc;";

 

 

多了个)导致截断 所有的记录全部不显示

posted on 2019-04-09 13:38  lydstory  阅读(215)  评论(0)    收藏  举报

导航