Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BitShift
Yak Posting Veteran
98 Posts |
 Posted - 2007-12-07 : 15:03:43
|
| Is it bad design to allow nulls on a date field ? I can think of one case such as a sale of an item and populating a field for the date of purchase, only when the purchase took place (and null until then).comments ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-07 : 15:13:04
|
| I use NULL in dates quite often. It is not exactly stored as null though, it is stored as 31/12/1899. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-08 : 10:40:16
|
any time you have a column where the data may be unknown, NULL is reasonable. for example, if you have a DateOfDeath column, that should be nullable (unless your database only contains dead people...)
elsasoft.org |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-10 : 01:58:01
|
| so as the terminated date of existing employeesMadhivananFailing to plan is Planning to fail |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-12-10 : 08:56:48
|
quote:
Originally posted by RickD
I use NULL in dates quite often. It is not exactly stored as null though, it is stored as 31/12/1899.
Are you sure you understand what NULL means?e4 d5 xd5 Nf6 |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-10 : 09:38:29
|
quote:
Originally posted by blindman
quote:
Originally posted by RickD
I use NULL in dates quite often. It is not exactly stored as null though, it is stored as 31/12/1899.
Are you sure you understand what NULL means?e4 d5 xd5 Nf6
Obviously not.. Bad day.. lol |
|
|
|
|
|
|
nullable date fields ?