Below are two functions that can be used to return the minutes portion from a datetime value in Oracle Database.
how to
How to Get the Short Month 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 month name. For example Nov or Dec (instead of November or December).
How to Add the Meridiem Indicator (AM/PM) to a Time Value in Oracle
When using the TO_CHAR() function to format a datetime value in Oracle Database, you can add the meridiem indicator (AM/PM) by simply adding either AM or PM to your format model.
Oracle then displays the appropriate meridiem indicator, depending on whether the time value is AM or PM.
You can provide it in any uppercase or lowercase, and with or without dots (e.g. AM, A.M. am, a.m, etc). Oracle will then display the meridiem indicator as specified.
5 Functions to Extract the Week Number from a Date in MariaDB
Below are 5 functions that enable you to return the week number from a date in MariaDB. Four return just the week, and one returns both the week and year combined.
How to Change your Session’s Currency Symbol in Oracle
In Oracle Database, there are a few different NLS parameters that determine how currency is displayed when using functions like TO_CHAR() to format a number as a currency.
NLS_CURRENCYspecifies the string to use as the local currency symbol for theLnumber format element.NLS_ISO_CURRENCYdetermines what to use for theCformat element.NLS_DUAL_CURRENCYspecifies what to use for theUformat element.
Get the Current Login ID in SQL Server (T-SQL)
You can use the SUSER_ID() function to return the login identification number of the current user.
You can also use it to return the login ID of another user.
This is similar to returning the current login name, except here we’re returning the ID instead.
2 Functions that Return the Month from a Date in Oracle
Below are two functions that can be used to extract the month from a date in Oracle Database.
6 Ways to Check your MariaDB Version
Here are six ways to check what version of MariaDB you’re currently running.
Find Out Which Quarter a Date Belongs to in Oracle
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.
How to Install Oracle Database on Windows
Below are the steps I used to install Oracle Database 18c XE on Windows 10.
Oracle Database 18c XE is the free Express Edition of Oracle. This is a good entry point into Oracle Database. XE is a regular Oracle Database, and it therefore provides compatibility with other Oracle Database editions. You can always move to another edition if you ever need to.