CREATE TABLE test1 (d_time Timestamp, mean VARCHAR(2)); SELECT * FROM test1 WHERE d_time BETWEEN to_timestamp('20100101','yyyymmdd') AND to_timestamp('20100101235959','yyyymmddhh24miss')
错了,我的字段类型是Date型,请问如何查呢
select maketime from tablename where to_char(maketime,'yyyy-mm-dd')='2010-01-01'
select maketime from tablename where to_char(maketime,'yyyymmdd')='20100101' 这样可能更好点吧
SELECT * FROM test1 WHERE d_time BETWEEN to_date('20100101','yyyymmdd') AND to_date('20100101235959','yyyymmddhh24miss')
select maketime from tablename where maketime=to_date('20100101','yyyymmdd')更好点的应该是这样吧,格式无关
(d_time Timestamp,
mean VARCHAR(2));
SELECT * FROM test1 WHERE d_time BETWEEN to_timestamp('20100101','yyyymmdd') AND to_timestamp('20100101235959','yyyymmddhh24miss')
from tablename
where to_char(maketime,'yyyy-mm-dd')='2010-01-01'
from tablename
where to_char(maketime,'yyyymmdd')='20100101'
这样可能更好点吧
from tablename
where maketime=to_date('20100101','yyyymmdd')更好点的应该是这样吧,格式无关