Date and time functions (Azure Cosmos DB)
APPLIES TO: SQL API
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:
Functions to work with DateTime values
The following functions allow you to easily manipulate DateTime, timestamp, and tick values: