|
|
|
|
|
|
|
|
|
|
|
Re: Number in date column [message #337694 is a reply to message #337594] |
Thu, 31 July 2008 13:27 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
The only reason you would want to store a zero in a date field is to flag it for special processing. You can do this two ways. Store a special date into the column
my_date := to_date('01/01/0001','mm/dd/yyyy')
which would be findable via an index or use a null, which would not be findable via an index.
my_date := null;
a number is impossible and makes no sense.
|
|
|
Re: Number in date column [message #337703 is a reply to message #337694] |
Thu, 31 July 2008 14:18 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
...or use a third and superior way: use a flag column to flag special occurrences and use the date column for what it is meant to store.
Using 'special' values will lead to trouble, sooner or later.
|
|
|