The AT TIME ZONE clause was introduced in SQL Server 2016 to convert a date into a datetimeoffset value in a target time zone.
This function is similar to some other T-SQL functions, such as SWITCHOFFSET() and TODATETIMEOFFSET(), however, the AT TIME ZONE clause allows/(requires) you to specify the time zone offset by name, instead of an actual offset value.
This article explores how AT TIME ZONE works, and explains its benefits when compared to the other functions mentioned.
In MongoDB, the $toUpper aggregation pipeline operator converts a string to uppercase and returns the result.
In MongoDB, the $toLower aggregation pipeline operator converts a string to lowercase and returns the result.
From MongoDB 4.0, you can use the $toObjectId aggregation pipeline operator to convert a string to an ObjectId.
The string must be a hexadecimal string of length 24.
Continue readingFrom MongoDB 4.0, you can use the $toLong aggregation pipeline operator to convert a value to a long.
From MongoDB 4.0, you can use the $toInt aggregation pipeline operator to convert a value to an integer.
From MongoDB 4.0, you can use the $toDouble aggregation pipeline operator to convert a value to a double.
From MongoDB 4.0, you can use the $toDecimal aggregation pipeline operator to convert a value to a decimal.
From MongoDB 4.0, you can use the $toBool aggregation pipeline operator to convert a value to a boolean.
From MongoDB 4.0, you can use the $toString aggregation pipeline operator to convert a value to a string.