I manage a fairly large estate of QGIS installs in the UK and am looking to set the default date formats to the uk dd/mm/yyyy format from our MSSQL data warehouse. Its set and works correctly in the database but QGIS defaults to YYYY-MM-DDT00:00:00. Is there an option anywhere for me to change the format of this display date globally?

I am aware I can do it via widgets however we have over 1000 datasets in the warehouse and any local datasets the users have would still be affected by the default date formatting.

  • 1
    why not fix MSSQL to use ISO date formats? – Ian Turton May 31 '18 at 10:23
  • 1
    Our SQL estate is managed by a 3rd party who set the standards and wont consider a change like that as it does not meet their "standards"... We have tried – Ian May 31 '18 at 10:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.