Changes between Initial Version and Version 1 of Ticket #1962, comment 26
- Timestamp:
- Jan 27, 2018, 5:18:41 PM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #1962, comment 26
initial v1 1 1 For reports, I had to modify the ORDER BY clause above for postgres 8.X to this: 2 2 3 {{{#!sql 3 4 ORDER BY 4 5 (CASE c.value WHEN '' THEN null ELSE date(substr(c.value,7,4)||'-'||substr(c.value,1,2)||'-'||substr(c.value,4,2)) END) 6 }}} 5 7 6 8 For 2 reasons: 7 1 )due_date is optional in my setup, so it can be '' -- hence the case statement.8 2)had to change the " to a ' for the strings.9 1. due_date is optional in my setup, so it can be '' -- hence the case statement. 10 1. had to change the " to a ' for the strings.