This may be a simple fix. Does anyone know how to change the date format in a query result? We just upgraded to v6.3 and the query results when running against all protocols are displaying the date in yyyy/mm/dd format. My team would prefer this to display as mm/dd/yyyy.
Yes, it is possible to change the date format in the query result view, please refer to the ‘date_format’ function on the Wiki page.
That is for an individual query. I’m curious if we can set a default date format for all queries created at any time. I would like to default the date format system wide.