bitscn.com
mysql日期比较语句 select * from student where '2012-02-27 00:00:00' created_date select * from student where unix_timestamp('2012-02-27 00:00:00') unix_timestamp(created_date); select * from student where (unix_timestamp(created_date) - unix_timestamp('2012-02-26 00:00:00') ) >= 0 and (unix_timestamp(created_date) - unix_timestamp('2012-02-29 00:00:00') )
有了这个函数，就可以很自然地把时间比较转换为一个无符号整数的比较。例如，判断一个时间是否在一个区间内unix_timestamp( time ) between unix_timestamp( 'start ') and unix_timestamp( 'end' ) bitscn.com