Android Question [RESOLVED] jdbcSQL date Value '0000-00-00' can not be represented

sigster · Jul 2, 2020

Hi

I am using jdbcSQL and mysql

when I try to get date I get this error

(SQLException) java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

B4X:

                Dim adate As String = Crsr.GetString("VV_date")
                If adate = Null Then adate = ""
                row(8) = " " & adate

makis_best · Jul 2, 2020

I think this caused by JDBC, add zeroDateTimeBehavior=convertToNull at the end of the jdbc connection string.
That will fix the problem. Do something like this..

B4X:

jdbc:mysql://127.0.0.1:3306?zeroDateTimeBehavior=convertToNull

Erel · Jul 3, 2020

Nulls and strings don't go well together.
If the above suggestion hasn't solved the issue then please post the full error message.

sigster · Jul 3, 2020

Thanks

this works

Android Question [RESOLVED] jdbcSQL date Value '0000-00-00' can not be represented

sigster

Active Member

makis_best

Well-Known Member

Erel

B4X founder

sigster

Active Member

Similar Threads

Android Question [RESOLVED] jdbcSQL date Value '0000-00-00' can not be represented

sigster

Active Member

makis_best

Well-Known Member

Erel

B4X founder

sigster

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency