SELECT * FROM TBLE WHERE TOCHAR(TABLE.DATE,YYYYMMDD)=TOCHAR(SYSDATE,YYYYMMDD) SELECT * FROM TBLE WHERE TOCHAR(TABLE.DATE,YYYYMM)=TOCHAR(SYSDATE,YYYYMM)
tochar为不可识别函数啊!大哥
SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMMDD')=TO_CHAR(SYSDATE,'YYYYMMDD') SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMM')=TO_CHAR(SYSDATE,'YYYYMM') 这样应该没错了 刚刚没细看
select * from FRPOLICY where TO_CHAR(pol_effectivedate,'YYYYMMDD')=TO_CHAR(SYSDATE,'YYYYMMDD') 你查下sql sever 中间 时间格式转换为字符格式的函数是什么,把to_char替换成该函数就可以了
select * from table1 where convert(char(10),date字段,20) =convert(char(10),getdate(),20)
oracle: SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMMDD')=TO_CHAR(SYSDATE,'YYYYMMDD') SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMM')=TO_CHAR(SYSDATE,'YYYYMM')sql server: select * from table1 where convert(char(10),date字段,20) =convert(char(10),getdate(),20) select * from table1 where left(convert(varchar(12),date字段,112),6) =left(convert(varchar(12),getdate(),112),6)
SELECT * FROM TBLE WHERE TOCHAR(TABLE.DATE,YYYYMM)=TOCHAR(SYSDATE,YYYYMM)
SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMM')=TO_CHAR(SYSDATE,'YYYYMM')
这样应该没错了 刚刚没细看
'to_char' 不是可以识别的 函数名。
你查下sql sever 中间 时间格式转换为字符格式的函数是什么,把to_char替换成该函数就可以了
SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMMDD')=TO_CHAR(SYSDATE,'YYYYMMDD')
SELECT * FROM TBLE WHERE TO_CHAR(TABLE.DATE,'YYYYMM')=TO_CHAR(SYSDATE,'YYYYMM')sql server:
select * from table1 where convert(char(10),date字段,20) =convert(char(10),getdate(),20)
select * from table1 where left(convert(varchar(12),date字段,112),6) =left(convert(varchar(12),getdate(),112),6)