time() in MySQL?

[notset]

Hello,

now to insert the curent time to the database i use:

SET time = '".time()."'

but maybe mysql have his own variable?

How to get the time in the TIMESTAMP format with MySQL?

Thanks.

[bogu]

UNIX_TIMESTAMP() .... <-- this is how u get TIMESTAMP in mysql

CURTIME() <-- mysql function to insert curent time ...

mktime() <-- php function for the curent timestamp ...