In PostgreSQL, we can use the extract()
function along with the epoch
argument to return the Unix timestamp.
We can return the Unix timestamp based on the current date/time, or we can get it based on another specified date/time.
Continue readingIn PostgreSQL, we can use the extract()
function along with the epoch
argument to return the Unix timestamp.
We can return the Unix timestamp based on the current date/time, or we can get it based on another specified date/time.
Continue readingHere are a couple of ways to return the number of days in a given month in Oracle Database. This could be the number of days in the current month, or the number of days in a month based on a specified date.
Continue readingIn SQLite, we can use the DATE()
function to subtract one or more days from a date.
For datetime values, we can use the DATETIME()
function.
Here’s a nifty trick we can use in MariaDB to return the number of days in a month based on a given date.
Continue readingBelow are three options for using T-SQL to return the first day of the month in SQL Server.
This could be the first day of the current month, or the first day of a month based on a given date.
Continue readingIn PostgreSQL, we can use the -
operator to subtract one or more minutes from a time value.
By “time” value, this could be an actual time
value, a timestamp
, or an interval
. We can also subtract minutes from a date
value or a date
and time
combination.
In SQLite, we can use the DATE()
function to add one or more months to a date.
When we’re dealing with datetime values, we can use the DATETIME()
function.
In Oracle Database we can use the LAST_DAY()
function to return the last day of a given month. This can be the last day of the current month or the last day of month based on a specified date.
We can use MySQL’s LAST_DAY()
function to return the last day of a given month.
This could be the last day of the current month, or the last day of the month based on a date that we specify.
Continue readingHere’s an example of using PostgreSQL to return the number of days in a month, based on a given date.
Continue reading