Item9196: Query search for date= fails in some timezones.

Priority:	CurrentState:	AppliesTo:	Component:	WaitingFor:
Normal	Confirmed	Engine	SEARCH

Test system running with GMT clock, timezone set to EST5EDT.

Test Fn_SEARCH::verify_date_param_PurePerlSearch Fails to find the topic with the Date stamp "1" - date 1970-01-01. The date query search appears to be using a timezone corrected date, and any timestamp less than 18000 (5:00 am) is actually for the prior date - 1969-12-31.

The topic timestamp appears to be using the server GMT time, while the search used in the test:

%SEARCH{"1" type="query" date="1969-12-31" format="$topic"}%

is offset for the system timezone.

• Server hardware time = GMT
• Server timezone EST5EDT
• Topic timestamp 18000 is found with date="1970"
• Topic timestamp 1, set in the unit test, found with date="1969-12-31" not, 1970.

-- GeorgeClark - 24 Jun 2010

Note that the unit tests that have been failing forever in negative timezones have been modified to work. But the underlying problem is still there.

-- GeorgeClark - 14 Mar 2011