[SOLVED] Best timestamp method to use?

[acctman]

What's the best Time/Date method to use when storing into a database? Mysql has a TIMESTAMP that will fill into automatically but there is also a time() that you can add during a php sql insert call.

 

any suggestion as to what i should use. right now i'm using the php time() and the entry into the db looks like this 1217123817

[DarkWater]

I'd use a DATETIME column and use the MySQL function NOW() to fill it.  If you need to format it, use DATE_FORMAT(), and if you need to get the timestamp, use UNIX_TIMESTAMP(), all of which are MySQL functions.

[acctman]

i tried using the now() and i'm receiving this error Fatal error: Call to undefined function: now()

 

        sql_query("INSERT INTO $logstable VALUES('$line[m_id]','$line[m_user]',".now().",'$ip') ".
"ON DUPLICATE KEY UPDATE log_user='$line[m_user]',log_time='".now()."',log_ip='$ip'");

[DarkWater]

It's a MySQL function I said. =P  Just put it right into the query:

 

INSERT INTO something (datecolumn) VALUES (NOW())

[acctman]

thanks