Use of sysdate() for MySQL not working

[eluser]extra_rice[/eluser]
the trans_datetime doesn't return the current date...

Code:

$data = array(
                'username' => $username,
                'lastname' => $lastname,
                'firstname' => $firstname,
                'middlename' => $middlename,
                'status' => 0,
                'pass_attr' => 0,
                'password' => $password,
                'landline_number' => $landlineNumber,
                'mobile_number' => $mobileNumber,
                'email' => $email,
                'trans_datetime' => 'sysdate()',
                'trans_user' => 0
        );
        
        $this->obj->db->insert($this->table, $data);

and this one without the single quote gives a PHP error...

Code:

$data = array(
                'username' => $username,
                'lastname' => $lastname,
                'firstname' => $firstname,
                'middlename' => $middlename,
                'status' => 0,
                'pass_attr' => 0,
                'password' => $password,
                'landline_number' => $landlineNumber,
                'mobile_number' => $mobileNumber,
                'email' => $email,
                'trans_datetime' => sysdate(),
                'trans_user' => 0
        );
        
        $this->obj->db->insert($this->table, $data);

any solutions guys?

[eluser]johnwbaxter[/eluser]
What does 'trans_datetime' return in your first example if it's not returning the current date?

[eluser]Seppo[/eluser]

Code:

$this ->obj->db->set('trans_datetime', 'sysdate()', FALSE);
$data = array(
                'username' => $username,
                'lastname' => $lastname,
                'firstname' => $firstname,
                'middlename' => $middlename,
                'status' => 0,
                'pass_attr' => 0,
                'password' => $password,
                'landline_number' => $landlineNumber,
                'mobile_number' => $mobileNumber,
                'email' => $email,
                'trans_user' => 0
        );
$this->obj->db->insert($this->table, $data);

[eluser]extra_rice[/eluser]
@audiopleb: thanks for the reply dude... just solved it using Seppo's solution

@Seppo: thanks dude! never thought i'd have to do it like that... thanks again!