34,333
edits
Changes
→Creating Date and Time Fields
`order_item` TEXT NOT NULL,
`order_date` DATETIME NOT NULL,
`order_delivery` DATE NOT NULL, PRIMARY KEY (`order_no`)
)
ENGINE = InnoDB;
</pre>
The order_date column is a DATETIME field because we want to record the precise time and date that the order was placed. For the delivery date it will be impossible to predict the exact time of day the package will arrive, so we just want to record the date.
== Date and Time Formats ==
