Error when creating table with curdate()

[3D-kreativ]

Hi,

 

I only get this error message in MySQL Workbench, version 5.2.25, "Error Code: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURDATE' at line 5"

 

CREATE TABLE Orders

(

OrderId int NOT NULL,

ProductName varchar(50) NOT NULL,

OrderDate datetime NOT NULL DEFAULT CURDATE(),

PRIMARY KEY (OrderId)

)

 

The code is from http://www.w3schools.com/sql/func_curdate.asp I'm surprised they have an example that not works!?

 

Preciate some help! Thanks!

[bh]

Hi,

 

In turn it seems ok. Try CURRENT_DATE() or CURRENT_DATE, which are synonyms of CURDATE

[3D-kreativ]

Thanks, but it didn't work! Strange!

[bh]

Then try it with NOW() function. NOW() is almost equivalent with CURDATE() except NOW() has time parts (but i think its ok for you).

[PFMaBiSmAd]

You cannot use a function to supply a default value. From the mysql documentation  -

... the default value must be a constant; it cannot be a function or an expression.

 

The disclaimer from the bottom of the w3schools web page -

We do not warrant the correctness of its content. The risk from using it lies entirely with the user.

 

You can cause the current datetime to be entered into a column if you use a TIMESTAMP data type -

The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column. See Section 10.3.1.1, “TIMESTAMP Properties”.

 

[3D-kreativ]

Hmm, so I can't use CURTIME and CURDATE when I create the table? I thought it was possible to get the time and date every time into each column when a new row is added to the table with other information? Could it be done in some other way? To use PHP date variables into the columns each time can't be better? If possible show me some code.

 

Preciate som help! Thanks!

[fenway]

You can, with magical TIMESTAMPs.

[3D-kreativ]

OK, like this: created TIMESTAMP DEFAULT NOW()

 

But is it possible to create a column each for date and time and separate them?

[fenway]

That's not the correct syntax -- check the refman.

 

No -- why separate two intricately related pieces of information?