As we are using triggers in PostgreSQL to fill Created Date or Modified Date with current date time, you need to ensure that you set the correct time zone for your location. By default PostgreSQL gives UTC date time.

I faced a situation where I had to change a column type from Boolean to Integer. And I wanted to rename the column name. For example, we have table that has a boolean column "bDeleted". I have to remane "dDeleted" to "iDeleted" and all boolean values need to convert into 0 and 1. Then you have to run below PostgreSQL queries.

PostgreSQL: to_char Function: The PostgreSQL to_char function converts a number or date to a string.

I just installed PostgreSQL in my local machine, since I am using XAMP. It is easy to integrate into XAMPP. This article helps you to install and integrate PostgreSQL in XAMPP.