DateTimeFromParts (Azure Cosmos DB)DateTimeFromParts (Azure Cosmos DB)

• 12/14/2020
• • r

适用于： SQL API

返回根据输入值构造的字符串 DateTime 值。Returns a string DateTime value constructed from input values.

语法Syntax

DateTimeFromParts(<numberYear>, <numberMonth>, <numberDay> [, numberHour]  [, numberMinute]  [, numberSecond] [, numberOfFractionsOfSecond])

参数Arguments

numberYear 年份的整数值，格式为 YYYYnumberYear Integer value for the year in the format YYYY

numberMonthnumberMonth
月份的整数值，格式为 MMInteger value for the month in the format MM

numberDaynumberDay
日期的整数值，格式为 DDInteger value for the day in the format DD

numberHour（可选）小时的整数值，格式为 hhnumberHour (optional) Integer value for the hour in the format hh

numberMinute（可选）分钟的整数值，格式为 mmnumberMinute (optional) Integer value for the minute in the format mm

numberSecond（可选）秒的整数值，格式为 ssnumberSecond (optional) Integer value for the second in the format ss

numberOfFractionsOfSecond（可选）表示秒的小数部分的整数值，格式为 .fffffffnumberOfFractionsOfSecond (optional) Integer value for the fractional of a second in the format .fffffff

返回类型Return types

以 YYYY-MM-DDThh:mm:ss.fffffffZ 格式返回 UTC 日期和时间 ISO 8601 字符串值，其中：Returns a UTC date and time ISO 8601 string value in the format YYYY-MM-DDThh:mm:ss.fffffffZ where:

备注Remarks

如果指定的整数将创建无效的 DateTime，则 DateTimeFromParts 将返回 undefined。If the specified integers would create an invalid DateTime, DateTimeFromParts will return undefined.

如果未指定可选参数，则其值为 0。If an optional argument isn't specified, its value will be 0.

示例Examples

以下是仅包含构造 DateTime 所需的参数的示例：Here's an example that only includes required arguments to construct a DateTime:

SELECT DateTimeFromParts(2020, 9, 4) AS DateTime

[
    {
        "DateTime": "2020-09-04T00:00:00.0000000Z"
    }
]

以下是另一个示例，该示例还使用一些可选参数来构造 DateTime：Here's another example that also uses some optional arguments to construct a DateTime:

SELECT DateTimeFromParts(2020, 9, 4, 10, 52) AS DateTime

[
    {
        "DateTime": "2020-09-04T10:52:00.0000000Z"
    }
]

以下是另一个示例，该示例还使用所有可选参数来构造 DateTime：Here's another example that also uses all optional arguments to construct a DateTime:

SELECT DateTimeFromParts(2020, 9, 4, 10, 52, 12, 3456789) AS DateTime

[
    {
        "DateTime": "2020-09-04T10:52:12.3456789Z"
    }
]

后续步骤Next steps

• 日期和时间函数 Azure Cosmos DBDate and time functions Azure Cosmos DB
• 系统函数 Azure Cosmos DBSystem functions Azure Cosmos DB
• Azure Cosmos DB 简介Introduction to Azure Cosmos DB