Default value in datetime column

elorob · #1 (**permalink**) 10-16-05, 08:57

Does anyone know the create table syntax to create a timestamp column that defaults to curtime(). This is to provide an audit trail for table inserts?

Thanks,

DG

Chagh · #2 (**permalink**) 10-17-05, 04:22

hi,
the default value for timestamp column is current date and you do not need to set a default value for it. see The DATETIME, DATE, and TIMESTAMP Types
to create a table with timestamp column:

Code:

create table test (fieldName TIMESTAMP);

for more info see create table

--Regards
Chagh

Internet Services

Web Development

Digital Marketing

Consumer Tech