qq_35482582的博客

需求是把policy_info表内的policy_end_time字段的时分秒都改成'23:59:59',年月日不变 下图是policy_info表内的policy_end_time字段(timestamp类型),用Navicat打开的 先是几个查询,可忽略 select count(*) from policy_info where RIGHT(policy_end_time,8) = '23:59:59'; select count(*) from policy_info where...