我一同事写的.记录一下 substr(char(timestamp),1,10) = #date# timestamp是表中timestamp字段 #date#是条件值 select * from table where substr(char(timestamp),1,10) = #date# 时间戳查询 ===========补充 日期类型查询 select * from table where date = 'yyyy-MM-dd' 时间戳类型查询 select * from table where time = 'yyyy-MM-dd HH:mm:ss'