current_timeStamp is not working

Question

I tried this code

CREATE TABLE users (
    userId INT PRIMARY KEY AUTO_INCREMENT NOT NUll,
    account VARCHAR(200) NOT NULL,
    password varchar(200) NOT Null,
    isActive varchar(10) NOT NUll,
    
    createdDate DATETIME DEFAULT CURRENT_TIMESTAMP() NOT NUll,
    updatedDate DATETIME 
);

but the following error will come

1067 - Invalid default value for 'createdDate'

thanks

Possible duplicate of [Invalid default value for 'dateAdded'](http://stackoverflow.com/questions/9005766/invalid-default-value-for-dateadded) — T3 H40, Jan 19 '16 at 07:10
which mysql version you are using ? before 5.6 it was only allowed for `timestamp` data type. — Abhik Chakraborty, Jan 19 '16 at 07:12
Use: `createdDate ` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, — Bernd Buffen, Jan 19 '16 at 07:12

Vipin Jain · Answer 1 · 2016-01-19T07:28:00.530

Use simply CURRENT_TIMESTAMP instead CURRENT_TIMESTAMP()

CREATE TABLE users ( 
    userId INT PRIMARY KEY AUTO_INCREMENT NOT NUll, 
    account VARCHAR(200) NOT NULL, password varchar(200) NOT Null, 
    isActive varchar(10) NOT NUll,
    createdDate DATETIME DEFAULT CURRENT_TIMESTAMP NOT NUll,
   updatedDate DATETIME 
);

In addition, you can initialize or update any TIMESTAMP column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL attribute to permit NULL values.

For more knowledge click the link http://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html

score 0 · Answer 2 · edited Jan 19 '16 at 07:19

0

Change the datatype datetime to timestamp it will work.

CREATE TABLE users ( userId INT PRIMARY KEY AUTO_INCREMENT NOT NUll, 
account VARCHAR(200) NOT NULL, 
password varchar(200) NOT Null, 
isActive varchar(10) NOT NUll,
createdDate **timestamp** DEFAULT CURRENT_TIMESTAMP() NOT NUll,
updatedDate DATETIME )

edited Jan 19 '16 at 07:19

Irshad

3,071
5
30
51

answered Jan 19 '16 at 07:15

Aashick

91
2
15

score 0 · Answer 3 · answered Jan 19 '16 at 13:03

Try this code, it should work.

CREATE TABLE users (
userId INT PRIMARY KEY AUTO_INCREMENT NOT NUll,
account VARCHAR(200) NOT NULL,
password varchar(200) NOT Null,
isActive varchar(10) NOT NUll,
createdDate DATETIME DEFAULT CURRENT_TIMESTAMP NOT NUll,
updatedDate DATETIME 
);

current_timeStamp is not working

1067 - Invalid default value for 'createdDate'

3 Answers3