更新时间:2023-02-14 10:21:16
Please use UDF in Cosmos DB.
示例文档:
sample document:
udf:
udf:
function convertTime(unix_timestamp){
var date = new Date(unix_timestamp*1000);
var year = date.getFullYear();
var month = ("0"+(date.getMonth()+1)).substr(-2);
var day = ("0"+date.getDate()).substr(-2);
var hour = ("0"+date.getHours()).substr(-2);
var minutes = ("0"+date.getMinutes()).substr(-2);
var seconds = ("0"+date.getSeconds()).substr(-2);
return year+"-"+month+"-"+day+" "+hour+":"+minutes+":"+seconds;
}
SQL:SELECT udf.convertTime(c._ts) FROM c
当然,在这种情况下,您可以使用多种格式:转换用JavaScript计时的Unix时间戳
Surely , you could refer to varied format in this case: Convert a Unix timestamp to time in JavaScript
希望它对您有帮助.