ADS : 14-rc-42
Platform : Ubuntu 12.04 64 bit
MongoDB : 2.4.4
With reference to the 'trafficdata.csv.zip' dataset (located at https://docs.google.com/file/d/0B7eDowaj5_6vQTFXNm8wX1hHLXc/edit?usp=sharing), when we search on 'crdt' field (date data type) for date in format such as 2013-09-26 00:25:51 AM on filter of ADS TDE, no results are returned even if there are documents with that date in the collection. However if we remove the AM/PM marker, search results are displayed.
Could you please investigate/fix this? Thank you
Issue #10386 |
Closed |
Duplicate |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
1 issue link |
duplicates #10190
Issue #10190Table data Editor does not work for searching date time string |
TDE filtering searches on the underlying data, not the data as displayed in any particular format. For Date values, the underlying data is in the JDBC format which uses a 24-hour format, and therefore AM/PM doesn't work in the filter.