[RESOLVED] date time problem

Hello there,

I have this query to update my users database.

[code=php]$updateQuery = “UPDATE wnl_users
SET
`usr_isFirstLogin` = FALSE,
`usr_lastLogin` = CURDATE()
WHERE
`usr_id` = ‘”.$_SESSION[‘id’].”‘
“;
[/code]

Specifically my concern here is the `usr_lastLogin` column. It’s mysql type set is DATETIME, but when I run the query all I get is ‘2011-03-23 00:00:00’. I want to save the time as well. Any ideas?

Thanks.

Also in #PHP _↴