疑惑很久了,再SQl plus 中条件是时间的怎么写啊,是加什么符号才可以
比如 selelct a from table where time between " 2002-02-12" and "2003-02-11" and a =a(+) 怎么老是报错啊,还有有是那个(+)有什么用啊
比如 selelct a from table where time between " 2002-02-12" and "2003-02-11" and a =a(+) 怎么老是报错啊,还有有是那个(+)有什么用啊
没见过是select吧
错误码贴出来
select a from table
where time between to_date('2002-02-12', 'yyyy-mm-dd')
and to_date('2003-02-11', 'yyyy-mm-dd')time 是data类型吗?