This article contains common examples of formatting dates in Oracle Database.
Continue readingAuthor: Ian
MariaDB FLOOR() vs TRUNCATE()
MariaDB has a FLOOR() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
Below is a quick rundown on the difference between FLOOR() and TRUNCATE() in MariaDB.
How to Return the Number of Seconds Past Midnight in Oracle Database
Oracle Database provides the SSSSS format element that enables us to get the number of seconds past midnight from a given datetime value.
MariaDB ROUND() vs TRUNCATE()
MariaDB has a ROUND() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
As the function names suggest, ROUND() rounds the number and TRUNCATE() truncates the number. Truncating a number simply cuts it off without performing any rounding.
Below is a quick rundown on the difference between ROUND() and TRUNCATE() in MariaDB.
How to Get the Month Name from a Date in Oracle
In Oracle Database, the TO_CHAR(datetime) allows us to return a datetime value, formatted in a way that we specify.
One of the things we can do is return the month name from a date.
Continue readingMariaDB ROUND() vs FLOOR()
MariaDB has a ROUND() function and a FLOOR() function that are similar in some ways, but quite different in other ways.
Below is a quick rundown on the difference between ROUND() and FLOOR() in MariaDB.
ROWIDTONCHAR() Function in Oracle
In Oracle Database, the ROWIDTONCHAR() function converts a ROWID value to NVARCHAR2 data type
It’s similar to the ROWIDTOCHAR() function, except that ROWIDTOCHAR() converts a ROWID value to VARCHAR2 data type.
ROWIDTOCHAR() Function in Oracle
In Oracle Database, the ROWIDTOCHAR() function converts a ROWID value to VARCHAR2 data type.
4 Ways to Format a Number Without Decimals in Oracle
When using Oracle Database, you can use functions like TO_CHAR(number) to return numbers as a string. This enables you to format the number to have a specific number of decimal places – including no decimal places, if that’s what you want.
You can also use functions like ROUND(number) and TRUNC(number) to round or truncate the number to no decimal places.
There’s also the CAST() function that allows you to cast a data type as an integer, which effectively removes any decimal places.
2 Ways to Format a Number with Leading Zeros in Oracle
When using Oracle Database to format a number to have leading zeros, we need to convert it to a string and format it accordingly.
You can use the TO_CHAR(number) function to format numbers with leading zeros.
And perhaps a lesser known fact, is that you can also use the LPAD() function to pad a number with leading zeros.