Actian/Pervasive SQL和日期变量

Question

在Actian Zen/Pervasive中如何声明和使用日期变量？

我该如何解决这个问题？

    CREATE proc test1 ()
returns(TranDate integer, GLAcntNumber integer , Net decimal(39,19))
as BEGIN 
    
DECLARE :StartDate DATE ;
SELECT CAST('2021-01-01' AS DATE) INTO :StartDate ;
SELECT :StartDate , GLAcntNumber, SUM(Net) AS Amt 
FROM vGLBalances 
WHERE period < 1
GROUP BY :StartDate, GLAcntNumber;

END

Answer 1

我收回这句话。我确实在你的查询中看到了一些东西。您正在创建日期，但试图将其作为整数传回。将您的查询更改为：

CREATE procedure test1 ()
returns(TranDate date, GLAcntNumber integer , Net decimal(39,19))
as BEGIN 
    
DECLARE :StartDate DATE ;
SELECT CAST('2021-01-01' AS DATE) INTO :StartDate ;
SELECT :StartDate, GLAcntNumber, SUM(Net) AS Amt 
FROM vGLBalances 
WHERE period < 1
GROUP BY :StartDate, GLAcntNumber;

END

应该能行得通。如果您确实需要Integer而不是date，则需要将查询从使用date改为使用date。