为什么在SQL查询中VBA函数不能用

Kelidai

前段时间做了一个查询工具，从oracle数据库中取数据。
想取收货日期的年月，结果：
Case "运营部要求"
SQL = "select account_id As 账套,rva05 As 供应厂商代号,rva06 As 收货日期,rvb04 As 采购单号,rvb05 As 料件编号,rvb08 As 收货量,rvb86 As 计价单位,PMM12 As 采购员,pmm22 As 采购单币别,pmn041 As 采购单中品名规格,ima021 As 料件规格,pmn31t As 本币含税单价,PMN94 As 客户编号,pmc03 As 简称,pmy02 As 厂商分类说明,pmc910 As 厂商类别，IMZ02 As 料件分群码说明,pma02 As 付款方式,rmb_pmn31 As 人民币未税单价,（rmb_pmn31*rvb08） as 金额,PMN10 As 类别代码,TC_AAD02 As 物料类别,year(rva06) As 年份 from " & myTable & " t WHERE t.rva06 between to_date('" & Starttime & "', 'yyyy-mm-dd') and  to_date('" & Endtime & "', 'yyyy-mm-dd') and （" & strictstring1 & "）"
会提示无法识别的year.
请大家帮忙，好久没有来论坛了，一来就是求助。

liuhoubin168

数据库。。。。。

zopey

排查法：
1、写个简单的sql语句 测试year函数 是否能用？

jsgj2023

sql中也有year函数呀!

Kelidai

jsgj2023 发表于 2018-3-28 17:14
sql中也有year函数呀!

方便的话，能不能帮我看看，我用的哪里不对？