Date and time functions (Azure Cosmos DB)

APPLIES TO: NoSQL

The date and time functions let you perform DateTime and timestamp operations in Azure Cosmos DB.

Functions to obtain the date and time

The following scalar functions allow you to get the current UTC date and time in three forms: a string which conforms to the ISO 8601 format, a numeric timestamp whose value is the number of milliseconds which have elapsed since the Unix epoch, or numeric ticks whose value is the number of 100 nanosecond ticks which have elapsed since the Unix epoch:

• GetCurrentDateTime
• GetCurrentTimestamp
• GetCurrentTicks

Functions to work with DateTime values

The following functions allow you to easily manipulate DateTime, timestamp, and tick values:

• DateTimeAdd
• DateTimeBin
• DateTimeDiff
• DateTimeFromParts
• DateTimePart
• DateTimeToTicks
• DateTimeToTimestamp
• TicksToDateTime
• TimestampToDateTime

Next steps

• System functions Azure Cosmos DB
• Introduction to Azure Cosmos DB
• User Defined Functions
• Aggregates