In PostgreSQL, we can use the upper() function to convert lowercase characters to their uppercase equivalent, according to the rules of the database’s locale.
psql
LOWER() – Convert to Lowercase in PostgreSQL
In PostgreSQL, we can use the lower() function to convert uppercase characters to their lowercase equivalent, according to the rules of the database’s locale.
Get the First Day of the Month in PostgreSQL
We can use the following method in PostgreSQL to return the first day of a given month.
This could be the first day of the current month, or the first day of the month based on a date that we specify.
Getting the first day of the month allows us to perform further calculations on the resulting date, like adding a certain number of days to the start of the month, etc.
Add Hours to a Time Value in PostgreSQL
In PostgreSQL, we can use the + operator to add one or more hours to a time value.
By “time” value, this could be an actual time value, a timestamp, or an interval. We can also add hours to a date value or a date and time combination.
INITCAP() – Convert to Initial Caps in PostgreSQL
In PostgreSQL, we can use the initcap() function to format a string of text to use initial capitals. That is, it converts the first letter of each word to upper case and the rest to lower case.
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.
PostgreSQL SHOW TABLES Equivalent (psql)
MySQL and MariaDB have a SHOW TABLES statement, which outputs a list of tables and views in a database. PostgreSQL doesn’t have a SHOW TABLES statement, but it does have a command that produces a similar result.
In Postgres, you can use the \dt command to show a list of tables. This is a psql command (psql is the interactive terminal for PostgreSQL).
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.