Re: Easy Date Searching Question

In article <CCJ729.Apz_at_vistachrome.com>, andy_at_vistachrome.com (Andrew Finkenstadt) writes:
> ditommm_at_aa.wl.com (Mr. Matteo diTommaso) writes:

>>Table Emp:
>>Ename char(100)
>>InDate date
>>Find all employees added 12/23/92 (any time of day).
>>select Ename
>> from Emp
>>where InDate = '23-DEC-92';
 
>>Will fail?

>>Thanks.
>>-- 
>>| Matteo diTommaso  (ditommm_at_aa.wl.com) |       /|                            |
>>| Ann Arbor, MI, USA                    |   \'o.O'      This space for rent.  |
>>| Phone: (313) 996-7148                 |   =(___)=                           |
>>| (Full disclaimer available by e-mail) |       U  ACK! THPTPHH!              |

Mr diTommaso,

The other thing you might consider here is the question "Do I really need the timestamp on this date?". If the answer is no, and you have access to the data and the sources of the data, you can TRUNC the dates. By using TRUNC(Date) when the data is entered into the database, all the dates will have the default time value (midnight) on them. Your original example would then work perfectly fine and the code would be clear, concise, and understandable. Unfortunately, this is usually not an option unless you are still in the design phase.

Andy

-- 
 /---------------------------------------------------------------------------\
 | Andrew Dowswell     | "...They bring me numbness in their bright needles, |
 | Parke-Davis (CPO)   |  they bring me sleep. Now I have lost myself..."    |
 | dowswea_at_aa.wl.com   |                                                     |
 | (313) 996-1337      |             Sylvia Plath "Tulips"                   |
 \---------------------------------------------------------------------------/