hi all.i am trying to show the dmi_queue_item's date_sent columnt in a datagrid.it can be seen in a strange format like:1331625863000.how can i show it in a proper format like dd/MM/yyyy?
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
you can use OTB custom tag in JSP 'datevalueformatter' like:
<dmf:datevalueformatter>
<dmf:label datafield='<field_name>'/>
</dmf:datevalueformatter>
or other option is, if you are fetching data through query, you can use datetostring function in query for this attribute like:
select datetostring(date_sent,'dd/mm/yyyy') as date_sent, ....
i chosed your second solution and it worked like a charm.thank you.
