When using the TO_CHAR(datetime) function in Oracle Database, you can use the Q format element to return the quarter that a given date belongs to.
Tag: date format
How to Get the Day Name from a Date in Oracle
With Oracle Database, we can use the TO_CHAR(datetime) function to return a datetime value, formatted in a way that we specify.
We can use this function to return the day name from a date (as well as any other parts of the datetime value).
Continue reading2 Ways to Get the Day from a Date in Oracle
Below are two functions that can be used to return the day from a date in Oracle Database.
Continue readingSupported Format Models for the ROUND() and TRUNC() Date Functions in Oracle
Below is a full list of the format models that are available to be used with the ROUND(date) and TRUNC(date) functions in Oracle Database.
2 Functions to Get the Year from a Date in Oracle
Below are two functions that can be used to extract the year from a date in Oracle Database.
Continue readingList of Datetime Format Elements in Oracle
Below is a full list of the datetime format elements in Oracle Database.
Continue readingHow to Check the Date Format of your Oracle Session
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).
How to Change the Date Format in your Oracle Session
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 readingHow to Get the Short Day Name from a Date in MariaDB
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).
3 Ways to Convert a String to a Date in MongoDB
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