Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Easy One
Message
General information
Forum:
ASP.NET
Category:
Databases
Title:
Miscellaneous
Thread ID:
00864178
Message ID:
00864696
Views:
14
Becareful with the use of BETWEEN. It's inclusive. In this case, you could pick up rows that were created 6 Jan 2004 12:00am. To capture rows for a single day, I perfer:

end_time >= '20040105' and end_time < '20040106'

-Mike


Good catch! Thanks, Mike!
Previous
Reply
Map
View

Click here to load this message in the networking platform