In SQL Server you can use the REPLACE() function to replace all occurrences of a string with another string.
The function accepts three arguments; the string that contains the string to be replaced, the string to be replaced, and the string to replace it.
Continue readingMongoDB has a Date BSON type that allows you to store dates as dates.
You can also store dates as strings, if that’s what you need.
Taking it a step further, you can also convert a Date to a string.
This article presents three ways to convert a Date to a string in MongoDB.
Continue readingIn SQL Server, you can use the MONTH() function to convert a month name to its corresponding number.
SQL Server provides the STUFF() function that enables you to insert a string inside another string.
The function also allows you to specify the number of characters (if any) to delete from the original string in order to fit the new string.
Continue readingThere are several ways to return the year from a date in SQL Server. Here are three (or is it four?).
Continue readingIf you need to add one or more seconds to a datetime value in MariaDB, here are 8 options to consider.
Continue readingHere are three ways to return the month name from a date in MariaDB.
Continue readingMariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a month (or many months) from a given date.
Here’s an example of subtracting a month from a date in MariaDB.
Continue readingThere are (at least) a couple of ways you can use T-SQL to return the default language of a specified login in SQL Server.
In particular, you can use the following methods:
LOGINPROPERTY() function. sys.server_principals system catalog view in the master database.Examples of these are below.
Continue readingIn SQL Server, you can use the sp_rename stored procedure to rename a user created object in the current database, including a user-defined data type.