[V4RB] Query returning unmatched records

[Ivan Smahin]

Hello Stan,

Wednesday, November 30, 2005, 4:39:33 PM, you wrote:

SB> Interesting, I searched the web on how do to that, so:

SB> WHERE ( myDate BETWEEN date'1/1/2001' AND date'1/31/2001' )

SB> is correct? If so I will try it. myDate is a DateTime field.

SB> Stan

You still should use the dates as defined by current dateFormat.
Date/DateTime/Time  literals  just gives  a  way  to  remove  some
internal ambiguities.

BTW. Using such literals is required by SQL-92.


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua