Error:The syntax of the string representation of a datetime value is incorrect.

While retrieving all values from database to a table i am getting the following error-
java.sql.SQLDataException: The syntax of the string representation of a datetime value is incorrect.
Attaching the code for retrieving the values to a table..
Also attaching the code of create statement during table creation..
Pls help..
show-Code.txt
create-stmt.txt
daydreamer6565Asked:
Who is Participating?
 
Gurvinder Pal SinghConnect With a Mentor Commented:
you date columns are varchar, which is why it is not coming as date

either
make those columns as date
or
fetch them as string and then convert to date
0
 
daydreamer6565Author Commented:
Now the error is gone..bt the values are not displayed on the table..what cud be the issue..
0
 
Gurvinder Pal SinghCommented:
Please put the print statements to check if the data is correctly retrieved from database
0
 
daydreamer6565Author Commented:
attaching the code pls suggest necessary changes so that it gets displayed in the table
also suggest the changes in my date code so as to print it in proper format..
show.txt
0
 
daydreamer6565Author Commented:
I got the values inside my table ..
now the issue is regarding Date only how to get the correct format?
pls help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.