Skip navigation links

MySQL Forums :: Newbie :: datetime data type


Advanced Search

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
Sweatshop

Options: ReplyQuote


Subject Written By Posted
datetime data type Claire Simkins 02/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.