In Oracle Database, the NLS_LANGUAGE initialization parameter specifies the default language of the database.
This language is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism.
The NLS_LANGUAGE parameter also determines the default values of the NLS_DATE_LANGUAGE and NLS_SORT parameters.
This article outlines how to change the value of the NLS_LANGUAGE and NLS_DATE_LANGUAGE parameters.
When using Oracle Database, you can find out what languages are supported by querying the V$NLS_VALID_VALUES view.
This view lists all valid values for NLS parameters, including supported languages.
When using Oracle Database, you can find out what territories are supported by querying the V$NLS_VALID_VALUES view.
This view lists all valid values for NLS parameters, including supported territories.
When working with functions that return dates, Oracle Database returns these dates based on the value of the NLS_DATE_FORMAT parameter.
There is also an NLS_TIMESTAMP_FORMAT parameter and an NLS_TIMESTAMP_TZ_FORMAT parameter, both of which have a datetime format mask that can be specified separately.
All of these parameters have their default values derived from the NLS_TERRITORY parameter (which by default, is operating system-dependent).
So, to change the date format for your session, you can either update the NLS_TERRITORY parameter, or explicitly update each parameter individually.
This article provides examples of checking and changing these values, and viewing the results.
In MariaDB, you can use the DATE_FORMAT() function to return various date parts from a date. One of the things you can return is the short day name. For example Tue or Wed (instead of Tuesday or Wednesday).
If you have a MongoDB collection with dates stored as strings, you can convert those into the Date BSON type if required.
Below are three ways to convert a string into a Date in MongoDB.
Occasionally you might find yourself in the situation where you need to get the name of the current workstation that’s connected to SQL Server.
For example, maybe you have a stored procedure that inserts data, and you want to record the name of the workstation that inserted the data.
In such cases, you can use the HOST_NAME() function.
This is not to be confused with getting the server name.
In MongoDB, the $unionWith aggregation pipeline stage performs a union of two collections, and it includes duplicates.
This behaves in a similar way to SQL’s UNION ALL, which also includes duplicates. By contrast, using just UNION (i.e. without the ALL)in SQL removes duplicates.
In MongoDB, we don’t have the option of specifying $unionWith ALL or similar, so we need to reduce duplicates in another way.
In MongoDB, we can remove duplicates by using the $group stage.
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.
If you need to return a small sample of random documents from a collection, here are three approaches you can try using the aggregation pipeline.