<@U1DCM39JR>: for DATE_ADD with days we wrote : `...

# exposed

[tapac]

@supaham: for DATE_ADD with days we wrote :

class DateAddDays(val dateExp: Expression<DateTime>, val addDays: Expression<Int?>) : Expression<DateTime>(){
    override fun toSQL(queryBuilder: QueryBuilder): String {
        return "DATE_ADD(${dateExp.toSQL(queryBuilder)}, INTERVAL IFNULL(${addDays.toSQL(queryBuilder)}, 0) DAY)"
    }
}

fun Expression<DateTime>.addDays(days: Expression<Int?>) = DateAddDays(this, days)

and you can use it in Exposed expressions:
Table.select { DateColumn eq OtherDateColumn.addDays( ColumnWithDaysCountToAdd ) }