In Oracle Database, we can use the TO_CHAR(datetime) function to return the various date parts from a datetime value, including the short month name.
The short month name is also referred to as the abbreviated month name. Examples of returning the short month name are below.
Continue readingIn Oracle Database, the UID function returns an integer that uniquely identifies the session user (the user who logged on).
If you’re using SQLcl to run queries against Oracle Database, then you can use the SPOOL command to export your query results to a CSV file.
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 reading