MariaDB has several functions that enable you to extract various date and time parts from date/time values. You can use these to separate each date/time component into its own column if required.
Below are four ways to extract the hours, minutes, and seconds from a time value in MariaDB. As a bonus, we’ll also include microseconds.
Continue readingWhen using Oracle Database, you can use the TO_CHAR(datetime) function to return various parts of a datetime value, including the fractional seconds.
To return the fractional seconds part from a datetime value, use the FF format element.
When using the TO_CHAR() function to format a datetime value in Oracle Database, you can add the AD/BC indicator by simply adding either AD or BC to your format model.
Oracle then displays the appropriate indicator, depending on whether the date value is AD or BC.
You can provide it in any uppercase or lowercase, and with or without dots (e.g. AD, A.D. ad, a.d, etc). Oracle will then display the indicator as specified.
Below are two functions that can be used to return the seconds portion from a datetime value in Oracle Database.
Continue readingThis article contains common examples of formatting dates in Oracle Database.
Continue readingOracle Database provides the SSSSS format element that enables us to get the number of seconds past midnight from a given datetime value.
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 readingWhen 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.
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.
When you use the TO_CHAR() function to format a number in Oracle, you use a format model to determine how the number should be formatted.
For example, you could format a number like 12,345.00 or like 12.345,00, depending on your locale.
The format model can include the G or D format elements to add a comma to a number. Which one you use depends on whether you want the comma as a thousands separator, or as a decimal character.
Alternatively, you can use an actual comma character (,) if you prefer, although this method is not locale aware like the G and D format elements are.