In SQLite, we can use the DATE() function to add a given number of days to a date.
If we’re dealing with datetime values, we can use the DATETIME() function.
dates
2 Ways to Return the Julian Day in SQLite
Here are two methods for returning the Julian Day in SQLite.
The Julian Day is the fractional number of days since noon in Greenwich on November 24, 4714 B.C. It’s the continuous count of days since the beginning of the Julian period, and is used primarily by astronomers, and in software for easily calculating elapsed days between two events.
Subtract Years from a Date in PostgreSQL
In PostgreSQL, we can use the - operator to subtract one or more years from a date.
Add Years to a Date in PostgreSQL
In PostgreSQL, we can use the + operator to add one or more years to a date.
Get the First Monday of a Year in SQLite
We can use SQLite’s DATE() function to return the date of the first instance of a given day of a given year. Therefore, we can use it to return the first Monday of a given year. We can also use it to return the first Tuesday, Wednesday, Thursday, Friday, etc.
We can use DATETIME() if we want a datetime value to be returned.
Add Weeks to a Date in PostgreSQL
In PostgreSQL, we can use the + operator to add one or more weeks to a date. We have a few options when it comes to specifying the actual number of weeks.
2 Ways to Return the Unix Timestamp in SQLite
The unix timestamp is the number of seconds since 1970-01-01 00:00:00 UTC. SQLite provides us with a couple of ways to get the unix timestamp.
Get the First Monday of a Month in SQLite
SQLite’s DATE() function provides us with the ability to return the date of the first instance of a given day of a given month. Therefore, we can use it to return the first Monday of a given month. We can also use it to return the first Tuesday, Wednesday, Thursday, Friday, etc.
We can use DATETIME() if we want a datetime value to be returned.
Get the Date/Time from a Unix Timestamp in SQLite
If you have a Unix timestamp, you can use SQLite’s DATETIME() function with the unixepoch modifier to compute the actual date and time.
You can alternatively use the DATE() function if you only need the date to be returned. And it’s also possible to use the TIME() function to return just the time portion.
Add Months to a Date in PostgreSQL
In PostgreSQL, we can use the + operator to add one or more months to a date. There are several options when it comes to specifying the actual number of months.