如何把这句sql语句转化为access可用的？

Question

select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,sum(CARD_EN) as CARD_EN,sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,convert(varchar(10),BUY_TIME,120) as date from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)
union all
select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),getdate(),120)
from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES

Answer 1

select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,sum(CARD_EN) as CARD_EN,sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,convert(varchar(10),BUY_TIME,120) as 'date' from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)
union all
select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),getdate(),120)
from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES
--date是保留字，加个引号。Convert函数Access中没有这个函数！

Answer 2

ACCESS 中没有替代 convert函数的么？