Datetime condition in 'where' - international problem

I use datetime condition in sql-query. For example:

select something from sometable
where date between '06/15/04 00:00:00' and '06/15/04 23:59:59'

and result on two synchronized servers is different.

In USA server result contains where date equal '06/14/04' only,
but Russian server gives where date equal '06/15/04'.

I read mysql online book article 'Writing International Transact-SQL Statements'
and not found any recommendations how solve this problem.

Thanks for any help.

I wouldn't use the time on the date search, just use the date only.

DateTimedatetimeJanuary 1, 1753 to December 31, 9999. Time values are stored in the time zone of the server.

Even if you drop time, you will have an issue. This will not solve all of your problems but look at this article:

http://sqlteam.com/item.asp?ItemID=204