This article contains common examples of formatting dates in Oracle Database.
Continue readingTag: dates
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.
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 reading2 Ways to Get the Minutes from a Datetime Value in Oracle Database
Below are two functions that can be used to return the minutes portion from a datetime value in Oracle Database.
Continue readingHow to Get the Short Month Name from a Date in MariaDB
In MariaDB, you can use the DATE_FORMAT() function to return various date parts from a date. One of the things you can return is the short month name. For example Nov or Dec (instead of November or December).
How to Add the Meridiem Indicator (AM/PM) to a Time Value in Oracle
When using the TO_CHAR() function to format a datetime value in Oracle Database, you can add the meridiem indicator (AM/PM) by simply adding either AM or PM to your format model.
Oracle then displays the appropriate meridiem indicator, depending on whether the time value is AM or PM.
You can provide it in any uppercase or lowercase, and with or without dots (e.g. AM, A.M. am, a.m, etc). Oracle will then display the meridiem indicator as specified.
5 Functions to Extract the Week Number from a Date in MariaDB
Below are 5 functions that enable you to return the week number from a date in MariaDB. Four return just the week, and one returns both the week and year combined.
Continue reading2 Functions that Return the Month from a Date in Oracle
Below are two functions that can be used to extract the month from a date in Oracle Database.
Continue readingFind Out Which Quarter a Date Belongs to in Oracle
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.
How 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 reading