I'm trying to use `DATE_ADD` (<https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#...

# squarelibraries

[Edwar D Day]

I'm trying to use DATE_ADD (https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-add) in an sql statement with sqldelight, but sqldelight complains '(', ')', '.', <binary like operator real>, BETWEEN or IN expected, got '6'
The used SQL code: date_add(current_date() , interval 6 month)
Am I doing something wrong or is there a workaround for such a case?

[alec]

needs to be added to the dialect: https://github.com/cashapp/sqldelight/blob/sql-psi-dev/dialects/mysql/src/main/kotlin/app/cash/sqldelight/dialects/mysql/MySqlTypeResolver.kt#L49

[Edwar D Day]

Ah okay. Workaround for the moment (if someone else comes along the problem)

makedate(year(current_date()), dayofyear(current_date()) + 183)

It's of course not accurate, but at least enough for me.

[alec]

👍 can you file a bug on sqldelight for this?

[Edwar D Day]

https://github.com/cashapp/sqldelight/issues/2969

[alec]

🙏