Question

SQL查某一天的数据怎么查

如题：select * from date where=2012-11-11正确应该怎么写、诚心求教！

Answer 1

你这个迅衫芦是SQL server，查询方式塌唯不一亩带样
select * from data where (括号里面是列名称) between '2012-11-11' and '2012-11-12'

Answer 2

SELECT * FROM 表名 WHERE date = TO_DATE('2012-09-18 15:18:47', '悔拆YYYY-MM-DD HH24:MI:SS'源前迅)
转换格式就对了。我雹此已经用过了

Answer 3

SELECT *
FROM t_table
WHERE DATE_FORMAT(checktime,'%Y-%m-%d'档姿)='2015-06-09'行乱绝陪州
ORDER BY id DESC LIMIT 1

Answer 4

select * from 数据表的名字 where date="2012-11-11"