Home » RDBMS Server » Server Administration » Re: Output of Query?
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?
Previous Topic: Re: Date format?
Next Topic: Re: Date format?
Goto Forum:
  


Current Time: Mon Dec 23 01:05:41 CST 2024