SELECT SUM(BALANCE) AS TOTALBAL,
SUM(ACCRUAL + BALANCE * DATEDIFF(day, VALDATE, DATE())) AS
TOTALAMOUNT
FROM PSTUSER WHERE (STATUS <> '9')"ACCESS中没有GETDATE()函数,改成DATE()就行了
SUM(ACCRUAL + BALANCE * DATEDIFF(day, VALDATE, DATE())) AS
TOTALAMOUNT
FROM PSTUSER WHERE (STATUS <> '9')"ACCESS中没有GETDATE()函数,改成DATE()就行了
DATEDIFF("D", VALDATE, DATE())
DATEDIFF('d', VALDATE, Date())