Question

Oracle中如何查询带日期的查询语句

select MOBILE from local_member where ( (FIRSTLOGINTIME between to_date(2010-2-1 00:00:00,'yyyy-mm-dd') and to_date(2010-2-28 23:59:59,'yyyy-mm-dd')) and ( lASTLOGINTIME between to_date(2010-2-1 00:00:00,'yyyy-mm-dd') and to_date(2010-2-28 23:59:59,'yyyy-mm-dd')))

Answer 1

简单号，ROACEL里查询日期带时间的是
to_date('20100201 00:00:00'，'YYYYMMDD hh24:mi:ss'芦斗)这样的。纳哗闭
你的语句可以改成

select MOBILE
from local_member
where ( (FIRSTLOGINTIME between to_date('20100201 00:00:00','yyyymmdd hh24:mi:ss') and to_date('20100228 23:59:59','yyyymmdd hh24:mi:ss')) and ( lASTLOGINTIME between to_date('20100201 00:00:00','yyyymmdd hh24:mi:ss'洞裂) and to_date('20100228 23:59:59','yyyymmdd hh24:mi:ss')))

Answer 2

select MOBILE
from local_member
where ( (FIRSTLOGINTIME between to_date('2010-2-1 00:00:00','yyyy-mm-dd hh24:miss') and to_date('正郑2010-2-28 23:59:59','yyyy-mm-dd hh24:mi:ss')) and ( lASTLOGINTIME between to_date('2010-2-1 00:00:00','yyyy-mm-dd hh24:mi:ss'举旦颂) and to_date('2010-2-28 23:59:59'迟明,'yyyy-mm-dd hh24:mi:ss')))

Answer 3

select MOBILE
from local_membe
where FIRSTLOGINTIME between to_date('1980-06-04','yyyy-mm-dd') and to_date('册基罩1987-07-09','yyyy-mm-dd');
如果锋老要加时分秒应该 to_date('州闹2010-2-28 23:59:59','yyyy-mm-dd hh24:mi:ss')

Answer 4

将所有'yyyy-mm-dd'替换成'yyyy-mm-dd hh24:mi:ss'