We have several map services with layers (created from SQL Server tables/views) that display datetime fields. We also have HTML popups defined for many of them (table of visible fields). The default format for date fields appears to be "M/dd/yyyy h:mm:ss tt", but I would like to change it to "yyyy-MM-dd HH:mm:ss". Is there a way to define a default format on the server, so that it will apply to all date fields? Or is there a way to specify the format in the MXD using ArcMap? Things I have already tried or thought about:
It feel like there should be a simple way to do this, but I'm missing it.