Re: Output of Query? [message #372405] |
Fri, 09 February 2001 08:47 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
Well, if sysdate = 3/Feb/2001 00:00:00
AND the dates in the file have null date time components as well, then the answer will be d)
as you will get the two rows with a date of 3/2/2001 and fld_1 = b
Otherwise you may get a row if the time component of sysdate matches the time component of one of the two valid rows mentioned above, or, which is more likely, you will get no rows.
Having trouble with a test are you?
|
|
|