Posted by --CELKO-- on 05/04/06 16:38

>> So once again - can someone explain why this query returns no records [sic] when begindate and enddate are specified as 5/3/2006 and there is clearly trade data with that tradetime? <<

Once again, because there is a DATETIME column which has a time on it.
If you do not give the time, it defautls to 00:00:00.000 Hrs. This is
a single point in time. What you wanted to use was

WHERE tradedate BETWEEN '2006-05-03 00:00:00.000' AND '2006-05-03
23:59:59.99'

You might also want to learn ISO standards and use 'yyyy--mm-dd' for
date values.

And do not forget to add constraints to temporal columns in your base
tables.

• Next in forum: Spring sale: 25% discount on all Upscene products!
• Prev in forum: Re: Partition function - Unknow range column
• Thread view: Re: Problem with using BETWEEN for date range...

[Reply to this message]