Home Postgresql returned timestamp format differes from test and prod db?
 I have a column called start_date in table X. In my php project, when I use a simple select * from table x where id = 1 to retrieve a row from table X in my test DB, the following is returned: {"id":1,"start_date":"2017-12-05 18:56:07"} Now when I do the same in my production database the following is returned: {"id":1,"start_date":"05\/12\/2017 18:56:07" Both my datebases have the same datestylewhich I have set to ISO,DMYusing ALTER DATABASE xx SET datestyle TO ISO, DMY; Why if both of these settings are the same and my production db is a restore of my test db, are these two queres returning different formats? Edit: Im using codeigniters query builder in my php project to retrieve the values from the db. I then view the value of the direct result using var_dump. Here is my php codeigniter method:  function get_last($id) {$this->db->where ( "id", $id); return$this->db->get ('table_x')->row_array (); }  If I replace the function with the following it works, but I would still like to know why the top is returning two different results.  function get_last($id) {$this->db->select("id, to_char(dataman, 'DD/MM/YYYY') as start_date"); $this->db->where ( "id",$id); return \$this->db->get ('table_x')->row_array (); }  This also makes me believe even more that postregsql is the reason the format is coming back different since by directly defining the format works.