|
Posted by Jim Armstrong on 05/03/06 23:40
OK - my post mentioned I originally used
WHERE tradedate BETWEEN begindate AND enddate
Begindate and enddate are not columns - they are parameters the user
supplies in the format mm/dd/yyyy.
My whole post was explaining that I would *prefer* to use the BETWEEN
AND statement - the converting was not my choice, but it is the only
way this query works when the user specifices the same date as
begindate and enddate.
So once again - can someone explain why this query returns no records
when begindate and enddate are specified as 5/3/2006 and there is
clearly trade data with that tradetime?
Navigation:
[Reply to this message]
|