java.sql.timestamp formatted differently on desktop vs jasper server

[lori.stopka]

Running Jaspersoft Server 7.1.0

 

jasperserver_config.properties  contains the following:

# Used for parsing and formatting dates by server
date.format=MM/dd/yyyy
datetime.format=MM/dd/yyyy HH:mm:ss

# Used for parsing and formatting dates by calendar component (UI).
calendar.date.format=mm/dd/yy
calendar.datetime.format=mm/dd/yy HH:mm:ss

 

For fields in a report with the class of java.sql.Timestamp, when no pattern is provided in the report, the format on the desktop displays correct

 

When report is run on server the format seems to be mixing up the minute and the month. 

 

Any suggestions / thoughts appreciated.

 

 

[dev.oliveira.rafael]

On the field add this java function new SimpleDateFormat("Y-MM-D HH:mm").format(<YOUR_VALUE_HERE>)

Remember of change the format pattern according your country

[lori.stopka]

Thanks for the response.  We do know that adding any pattern to the field in Studio resolves the issue or as you suggest, formatting the field itself,  but that requires touching each report.  We are trying to determine why the issue even exists.  If no pattern is provided you would expect the format of the field to be as defined in the config file on the server but it is not.   We have hundreds of reports and no way to identify which ones have date fields without patterns.  We are fixing them (providing a pattern) as they present themselves.  Existing reports were working as expected for years so we suspect something changed on the server but we don't know what that something is.