Open
Bug 728415
Opened 13 years ago
Updated 13 years ago
Query on "Creation date" "is equal to" not working as expected
Categories
(Bugzilla :: Query/Bug List, defect)
Tracking
()
UNCONFIRMED
People
(Reporter: jeffwang, Unassigned)
Details
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11
Steps to reproduce:
Create a bug in Bugzilla 4.2rc2;
Assume the value for reported field is:2012-02-16 11:36 PST
In advanced query, select "create date", "contains string" "2012-02-16 11:36" to perform search. There will be one bug shown up as result, click the XML button and found:
<creation_ts>2012-02-16 11:36:00 -0800</creation_ts>
Now select "Creation date" "is equal to" "2012-02-16 11:36:00 -0800" to search. Then try "Creation date" "contains the string" "2012-02-16 11:36:00 -0800" to search.
Actual results:
The last 2 searches with value "2012-02-16 11:36:00 -0800" did not return any result.
Expected results:
Those two searches should return the bug that was just created.
|
||
Comment 1•13 years ago
|
||
You must not include the timezone offset in the field.
Status: UNCONFIRMED → RESOLVED
Closed: 13 years ago
Resolution: --- → INVALID
|
|
||
Updated•13 years ago
|
Assignee: general → query-and-buglist
Component: Bugzilla-General → Query/Bug List
Try "Creation date" "is equal to" "2012-02-16 11:36:00" search. It still did not return any result.
Status: RESOLVED → UNCONFIRMED
Resolution: INVALID → ---
|
|
||
Comment 3•13 years ago
|
||
(In reply to teapot from comment #2)
> Try "Creation date" "is equal to" "2012-02-16 11:36:00" search. It still did
> not return any result.
You assumed that because 11:36 is displayed, this means 11:36:00. But the UI simply dropped seconds. Try "2012-02-16 11:36" instead.
Status: UNCONFIRMED → RESOLVED
Closed: 13 years ago → 13 years ago
Resolution: --- → INVALID
Tried the following:
"Creation date" "is equal to" "2012-02-16 11:36" search. It still did not return any result.
In another word, it always failed with or without seconds. What exactly is the value stored into that field? Could that be GMT time?
Status: RESOLVED → UNCONFIRMED
Resolution: INVALID → ---
|
|
||
Comment 5•13 years ago
|
||
(In reply to teapot from comment #4)
> In another word, it always failed with or without seconds. What exactly is
> the value stored into that field? Could that be GMT time?
It stored with the timezone defined in your DB server.
What is the correct value to use to make the query with "is equal to" to return a result?
You need to log in
before you can comment on or make changes to this bug.
Description
•