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