How Do I Create A Column That Will Default To The Current Time?

1.	How Do I Create A Column That Will Default To The Current Time?
Answer» Use CURRENT_TIMESTAMP: CREATE TABLE TEST (x INT, modtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); Use CURRENT_TIMESTAMP: CREATE TABLE test (x int, modtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Answer»

Use CURRENT_TIMESTAMP:
CREATE TABLE TEST (x INT, modtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Use CURRENT_TIMESTAMP:
CREATE TABLE test (x int, modtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Discussion