Client has a date field which is stored in database as a date/time.
The field is defined as follows in schema.xml:
<field name="TRANSACTION_DATE" type="tdate" indexed="true" stored="true"
multiValued="false" required="false" />
Where tdate is:
<!-- A Trie based date field for faster date range queries and date faceting.
-->
<fieldType name="tdate" class="solr.TrieDateField" precisionStep="6"
positionIncrementGap="0"/>
Query is formatted as follows (this is shortened for ease of reading):
'/solr/aml/select?q=TRANSACTION_REFERENCE_NUMBER%253A%2522${transactionReferenceNumber}%2522&wt=json&fl=_1_Trigger:def(TRIGGER_IND,%2522N%2522),_4_Transaction_Date:TRANSACTION_DATE,_5_Amount:CURRENCY_AMOUNT,%26fq=doc_type%253Atrxn&rows=100000&start=0'
I would like to return the transaction date as a date without the time stamp or
time zone but instead it looks like this:
[cid:image001.png@01D83A1E.923275C0]
Do you know how I might have it strip the timestamp and time zone using a
function in the query? Or do I have to change schema.xml (and to what)?
Thank you!!
Teresa
