为什么我的'2014'日期有误？

Question

为什么我的'2014'日期有误？

Some Select Clause
Some Where Clause
AND TRAN_DT DATE BETWEEN '2014/04/01' AND'2014/04/30'

Answer 1

因为你有一个额外的不需要的词。您TRAN_DT DATE中间有一个空格。用

AND TRAN_DT BETWEEN '2014/04/01' AND'2014/04/30' -- if column is [TRAN_DT]

或

AND [TRAN_DT DATE] BETWEEN '2014/04/01' AND'2014/04/30' -- if column is [TRAN_DT DATE]