您可以在cosmos db集合中定义udf.

You could define an udf in your cosmos db collection.

function getLastHourTime(){
    var date = new Date();
    var a = date.setHours(-1);
    return a;
}

将您的sql修改为:

SELECT * FROM c where c.time >= udf.getLastHourTime()

注意:udf.getLastHourTime()返回 Unix时间戳，您需要匹配格式.

Note: udf.getLastHourTime() returns Unix time stamp , you need to match the format.

希望它对您有帮助.