Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Date format for reports does not work with default postgres datetype setting in Ireland. #13

Open
scrudden opened this issue Aug 18, 2015 · 2 comments

Comments

@scrudden
Copy link
Contributor

Reports use dates in ISO, MDY format for the date fields. If you set up a postgres database it uses lc_time locale behaviours as the default which in Ireland expects ISO, DMY.

From the postgres docs

The built-in default is ISO, MDY, but initdb will initialize the configuration file with a setting that corresponds to the behavior of the chosen lc_time locale.

@scrudden
Copy link
Contributor Author

Just a problem, in the JSP predAccuracyCSV.jsp when formatting date in sql. Can use Time.parse on start and end dates from form and set these as parameters to the query rather than just appending text.

@scrudden
Copy link
Contributor Author

Have changed all instances where string dates where used in reports to ? parameters in branch issue_13 on my fork. Will rebase this and send pull request over weekend.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant