如何查某一天的数据

Question

to_char(create,'yyyy-mm-dd')>='2006-2-24' and to_char(create)<='2006-2-24'

Answer 1

to_char(create,'yyyy-mm-dd')>='2006-02-24' and to_char(create,'yyyy-mm-dd)<='2006-02-24'

Answer 2

为什么要大于等于又要小于等于,直接等于不就行了
to_char(create,'yyyy-mm-dd')='2006-02-24'

Answer 3

还没有人知道吗?to_char(create,'yyyy-mm-dd')>='2006-02-24' and to_char(create,'yyyy-mm-dd)<='2006-02-24'这样可以,但还有些问题

Answer 4

冒充专家点评一下(大家不要码我啊):where created >= to_date('2006-2-24','yyyy-mm-dd')
  and created <= to_date('2006-2-24','yyyy-mm-dd')
只判断了一秒钟,因为to_date('2006-2-24','yyyy-mm-dd') = '2006-02-24 00:00:00'where to_char(create,'yyyy-mm-dd') >= '2006-02-24' 
  and to_char(create,'yyyy-mm-dd') <= '2006-02-24'
理论上是正确的,但不够简洁.to_char(create,'yyyy-mm-dd')='2006-02-24'这样就是最好的方式.

Answer 5

WHERE SUBSTR(TO_CHAR(CREATED),1,9)='2006-2-24'

Answer 6

错了,应该是:where substr(to_char(created),1,10)='2006-02-24'