dateInsert SMALLDATETIME NULL DEFAULT getdate for MySQL

anselme · #1 (**permalink**) 12-23-07, 11:46

I am looking for the equivalent of MS SQL

dateInsert SMALLDATETIME NULL DEFAULT getdate()

for mySQl 5

i am trying

dateInsert DATETIME NULL DEFAULT NOW()

but it doesnt work

thank you for helping

r937 · #2 (**permalink**) 12-23-07, 15:24

dateInsert TIMESTAMP

will also update every time the row is changed

anselme · #3 (**permalink**) 12-24-07, 01:41

thank you r967 but I only want to store the dateInsert once to sort or search datas latter on the INSERT date, is there anything for mysql ?

r937 · #4 (**permalink**) 12-24-07, 05:07

dateInsert DATETIME

unfortunately you cannot set the DEFAULT value to a function like NOW()

anselme · #5 (**permalink**) 12-24-07, 05:22

ok thank you

Internet Services

Web Development

Digital Marketing

Consumer Tech