Dates...

[B14speedfreak]

Hi all,

I am in the process of changing some Oracle sql scripts to work with mysql. Anyhow I have this script that creates tables, I think I have converted most of it to work. I get this problem when I run the <b>source</b> command to execute the sql script, when I try to do the following:

<b><i> CREATE TABLE customerorders(
ORDERID INT NOT NULL,
OrderDate DATE DEFAULT CURRENT_DATE NOT NULL,
.....
);</i></b>

Its the current date thats causing me the problems. Has anyone got any ideas how what I can use instead of <b>CURRENT_DATE</b> so that I get todays date as a default?

Thanks again,



B14... aka... Marky Mark... the frozen monkey in the server room...

 

[TonyGroves]

You can only use a constant value as a field's default value. (One exception is that you can use CURRENT_TIMESTAMP as the default for a TIMESTAMP field but not for a DATE field).

You will just have to provide a value for the OrderDate field each time.

 

[B14speedfreak]

Ok Thanks for the replay thats very useful....

B14... aka... Marky Mark... the frozen monkey in the server room...