QueryBuilder with postgreSQL and timestamp.

You can implement the afterFetch() method in a model, this event will be executed just after create the instance and assign the data to it. Something like this:

    public function beforeSave()
    {
        $this->timestamp = date("Y-m-d H:s:i", $this->timestamp);
    }

    public function afterFetch()
    {
        $this->timestamp = strtotime($this->timestamp);
    }

    public function afterSave()
    {
        $this->timestamp = strtotime($this->timestamp);
    }