Timeline for casting LEFT() from string to integer
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 15, 2018 at 18:24 | history | edited | Vérace | CC BY-SA 4.0 |
added 31 characters in body
|
| May 15, 2018 at 13:59 | comment | added | Vérace |
Hmm... yes, puzzling - but the error ERROR: invalid input syntax for integer: "13/1" SQL state: 22P02 suggests perhaps that there's a date in the format '13/1/XXXX' in there somewhere? Not really sure why. I do think that my answer is more "PostgreSQL-esqe" (c.f. Pythonesque).
|
|
| May 15, 2018 at 13:59 | vote | accept | Spatial Digger | ||
| May 15, 2018 at 13:59 | comment | added | Spatial Digger | There was a data error, fixing the data makes this work | |
| May 15, 2018 at 13:53 | comment | added | Spatial Digger | cast AS or :: should not make the difference | |
| May 15, 2018 at 13:43 | history | answered | Vérace | CC BY-SA 4.0 |