This is a discussion on Storing orders question within the MySQL forums, part of the Database Server Software category; --> Hi All I have design question about storing weekly orders. In the current problem the order has delivery details ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi All I have design question about storing weekly orders. In the current problem the order has delivery details that only need to identify which week it should be delivered - not the exact day. Given this is it better to store the delivery details: (a) using week and year fields; or (b) using a date that falls in the week of delivery? There appears to be complexities on both sides (commercial dates, 53 weeks in some years, etc...) I would love to hear anybodies thoughts or experiences with this situation? Thanks Adrian |