Doubt

[Sreevatsava Varada]

Hi,

   I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I used to give the 
default value 'GetDate()' for a field in the database with the datetime datatype. In 
mySQL I tried using Now(). But when I insert a new row the datetime field is taking 
0000:00:00 00:00:00 value. Please let me know what should I give as the default value 
for 'record_date' field (of datetime datatype) so that it takes the value returned by 
Now() function when a new row is inserted using php script.


Thanks.