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: how 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.
Continue readingFix: “the leading precision of the interval is too small” in Oracle Database
If you’re trying to use an interval literal in Oracle, but you keep getting the “leading precision of the interval is too small” error, hopefully this helps.
Continue readingHow 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 readingHow to Calculate Age in MariaDB
In MariaDB, you can use the TIMESTAMPDIFF() function to calculate a person’s age (or the age of anything for that matter).
TIMESTAMPDIFF() is a built-in date and time function that returns the difference between two date or datetime expressions. Passing YEAR as the first argument, date of birth as the second argument, and the current date as the third, will return the age in years.
How to Install Windows 10 on an M1 Mac for Free
In 2020, Apple introduced Mac computers with Apple silicon, with the first chip being the Apple M1.
This was a major change, and it affected many third party applications to the point where they simply don’t run on the M1 Mac.
One application that doesn’t run on M1 Macs is VirtualBox. Prior to the M1 Mac, we could use VirtualBox to install Windows on our Mac. VirtualBox is a free virtualisation application that enables you to install virtual machines (with other operating systems) on your Mac.
Fortunately, there’s a free alternative to VirtualBox – UTM.
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 readingFix “Cannot install in Homebrew on ARM processor in Intel default prefix (/usr/local)!”
I recently tried to install QEMU on my M1 Mac but received the “Cannot install in Homebrew on ARM processor in Intel default prefix” error.
Here’s how I fixed the issue.
Continue reading2 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 reading4 Ways to Change the Time Zone in Oracle
In Oracle Database, time zones can be set in various places. Below are four ways to change the time zone when using Oracle.
Continue reading