Convert string type fields to datetime type _ mysql in MySQL statements

Convert string type fields to datetime type bitsCN.com in mysql statements
In a mysql statement, convert a string-type field to a datetime-type field. in mysql, use str_to_date () to convert a string to a date. here, the Start_time and End_time fields in the h_1_context table are used as an example, query the data within the specified time range. Select * from h_shortcontext where now () between STR_TO_DATE (Start_time, '% Y-% m-% d % H: % I: % S') and STR_TO_DATE (End_time, '% Y-% m-% d % H: % I: % S'); Note:' % Y-% m-% d % H: % I: % s' format: 2012-10-11 16: 42: 30bitsCN.com