Database Management Systems
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 readingIf 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 readingWith 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 readingIn Oracle Database, the BIT_TO_NUM() function converts a bit vector to its equivalent number.
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.
In Oracle Database, the ASCIISTR() function returns an ASCII version of the given string in the database character set.Â
Below are two functions that can be used to return the day from a date in Oracle Database.
Continue readingI 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 readingBelow is a full list of datetime functions available in Oracle Database.
Continue readingIn Oracle Database, the TRUNC(date) function returns the given date value with the time portion of the day truncated to the unit provided in the specified format model.
Oracle also has a TRUNC(number) syntax, which is used on numbers. This article is solely about the TRUNC(date) syntax, which is used on dates.