https://blog.csdn.net/ljj125896/article/details/84034652?utm_medium=distribute.pc_aggpage_search_result.none-task-blog-2~all~first_rank_v2~rank_v28-1-84034652.nonecase&utm_term=varchar%E8%BD%AC%E6%8D%A2%E6%88%90date&spm=1000.2123.3001.4430
https://blog.csdn.net/liu865033503/article/details/81289259?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.channel_param
-- VISIT_TIME 是varchar VISIT_TIME_STRING 是datetime
SELECT id, VISIT_TIME, VISIT_TIME_STRING FROM MEM_VISIT_APPOINTMENT WHERE VISIT_TIME_STRING > NOW();
SELECT id, VISIT_TIME, VISIT_TIME_STRING FROM MEM_VISIT_APPOINTMENT WHERE STR_TO_DATE(VISIT_TIME,'%Y-%m-%d %k:%i:%s' ) > NOW();
-- STR_TO_DATE('2012-8-8 14:58:09','%Y-%m-%d %k:%i:%s' ) A
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZuBnL0ETM2QzN0UTM0ATMxAjMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)