How to Change the Date Format in your Oracle Session

Posted on August 6, 2021August 10, 2021 by Ian

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.

Continue reading →

How to Get the Short Day Name from a Date in MariaDB

Posted on August 4, 2021 by Ian

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).

Continue reading →

3 Ways to Convert a String to a Date in MongoDB

Posted on August 3, 2021 by Ian

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.

Continue reading →

Change the Time Zone Offset on a datetimeoffset Value in SQL Server (T-SQL)

Posted on July 28, 2021 by Ian

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 reading →