[RESOLVED] date problem

[kingdm]

Can anyone assist me regarding this DATETIME issue.

I have this insert snippet:

$query = "INSERT into `wnl_users` ( `dateuploaded` ) VALUES ( CURDATE() )";

On my mySQL the type of column "dateuploaded" is datetime.

However, when I run the query the value inserted on the dateuploaded was "2011-04-02 00:00:00", the time is zero. Is there any way I can have those time the exact time I inserted the query?

Help is much appreciated.

Thanks.

[bradgrafelman]

The time is all zeros since that's what you told MySQL to insert - just the current date (as in CURDATE/b). If you want the current date and time, use a function such as NOW() which returns both.