Skip to main content

Timeline for Error using convert MySQL in Python

Current License: CC BY-SA 4.0

10 events
when toggle format what by license comment
Apr 29, 2020 at 9:38 vote accept Memmo
Apr 29, 2020 at 9:38 answer added Memmo timeline score: 0
Apr 29, 2020 at 3:24 comment added Rick James The error is pointing to "getdate"; look that up. When you don't find it, search for "MySQL date functions".
Apr 24, 2020 at 7:18 history edited Memmo CC BY-SA 4.0
add comma
Apr 22, 2020 at 9:54 comment added danblack previous links, and just noticed MariaDB in the error so linked its documentation too. Keep asking if you get stuck however.
Apr 22, 2020 at 9:28 comment added Memmo Really? And where is this documentation available?
Apr 22, 2020 at 9:15 comment added danblack your link is for SQL-Server. Quite different product. Some SQL is the same, some different. There's enough MySQL documentation to keep you from guessing what is/isn't correct. The good thing about MySQL/MariaDB errors is they point exactly where the problem is.
Apr 22, 2020 at 9:11 comment added Memmo I have tried NOW(). It works very well, thanks @danblack! I found the convert documentation here. But at this point I believe it is totally incomplete.
Apr 22, 2020 at 8:54 comment added danblack The CONVERT syntax you have here isn't mysql. What do you want this expression to return? NOW() is the current date (and other date functions in the link).
Apr 22, 2020 at 8:47 history asked Memmo CC BY-SA 4.0