Im using postgres 7.2 and PHP, all im trying to do is insert a timestamp into the DB, but coming up with this error.
Query failed: ERROR: Bad timestamp external representation '0.78784300 1058879269'
Here is the code:
$time = microtime();
$sql = "UPDATE tbllogin SET last_loggedin= '$time' WHERE employee_id =$employee_id";
$result = pg_query($sql);
Am i doing something stupid here? The last_loggedin field is set to timestamp data type.
Thanks in advance..