在Azure CosmosDB SQL查询中将TimeScript转换为日期 [英] Convert TimeScript to Date in Azure CosmosDB SQL Query

问题描述

如何选择日期可读格式的文档时间表?我想做这样的事情:

How can I select the timescripts of my documents in Date readable format? I want to do something like this:

SELECT CAST(C._ts AS DATE) FROM C

请仅针对Cosmos DB SQL查询.

Specific to Cosmos DB SQL Query only please.

推荐答案

请使用

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

希望它对您有帮助.

这篇关于在Azure CosmosDB SQL查询中将TimeScript转换为日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！