SQL recording time date?

Question

how do i record the time and date in sql tables
the zeros aint moving 0000-00-00-00:00:00

am using the DATETIME function, i know theres a zillion ways, i just want one that does the job..

Answer 1

INSERT INTO table (recorded) VALUES (now());

This should work in MySQL. In Oracle you might want to use something like SYSDATE.
Is that what you wanted?

PS. It looks like SYSDATE() will also work in MySQL.

Answer 2

The easiest way is to use SYSDATE. That will give you the current date and time down to seconds. Using TIMESTAMP can get it down to 9 decimal places of seconds.

Just, if you are updating, use SET datetime_col = SYSDATE.