Transitime 0.1 (beta) is an open source project created and managed by Swiftly, Inc. to help transit agencies generate more accurate and reliable real-time arrival information for passengers. This version of the code is an early beta release and should not be used for production implementations. Please reach out to Swiftly at contact@goswift.ly for the most up-to-date software.
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.
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.
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.
scrudden
commented
9 years ago
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.