You can use the SWITCHOFFSET() function in SQL Server to change the time zone offset on a datetimeoffset value.
The function accepts two arguments; a datetimeoffset(n) value (or an expression that can be resolved to a datetimeoffset(n) value), and the new time zone.
Continue readingThis article lists the various aggregation pipeline operators that can be used to return individual date parts from a Date object in MongoDB.
Continue readingBelow are 4 functions that enable you to return the hour from a time value in MariaDB.
Continue readingMariaDB has quite a number of functions that return the day from a date. It all depends on how you want to do it, and what you mean by “day”.
MariaDB needs to know whether you want the day name, the day of the week number, the day of the month, day of year, etc.
Below are 8 functions that enable you to return the day from a date in MariaDB, in its various forms.
Continue readingHere are two ways to return the short month name from a date in MariaDB.
Continue readingBelow are 4 functions that enable you to return the minutes portion from a time value in MariaDB.
Continue readingMariaDB includes many functions that allow you to return time and datetime values in a variety of formats.
Two functions allow you to format the time portion using a 12 hour clock, with the AM/PM designator are DATE_FORMAT() and TIME_FORMAT().
There are many format specifiers that can be used with these functions, but only a couple that return the AM/PM designator.
Continue readingMariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a year (or many years) from a given date.
Here’s an example of subtracting a year from a date in MariaDB.
Continue readingBelow are 4 functions that enable you to return the seconds part from a time value in MariaDB.
Continue readingMariaDB provides many ways to perform date arithmetic. This includes adding or subtracting a certain number of a given date part from a date or datetime value.
In this article, I present 8 ways to add one or more minutes to a datetime value in MariaDB.
Continue reading