MySQL Forums
Forum List  »  Newbie

datetime data type
Posted by: Claire Simkins
Date: February 02, 2005 04:34AM

I'm having problems with the datetime data type in my database. In one of my tables, I have a field called 'order_ShipDate' which has a data type of 'datetime' and the default is set to '[NULL]'.

I am trying to set up a similar field in a different table called 'orderSKU_ShipDate', but when I set the data type as 'datetime' and the default as '[NULL]', it automatically changes the default to '0000-00-00 00:00:00'.

How do I stop this happening? You obviously can just have a default of [NULL] but it isn't letting me when I create a new field. I'm using the MySQL Control Center to administer my database.

Kind regards

Claire Simkins
Web master/designer

Options: ReplyQuote

Written By
datetime data type
February 02, 2005 04:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.