Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-04-03
5
Medium Priority
?
1,125 Views
Last Modified: 2012-04-06
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
0
Comment
Question by:daydreamer6565
  • 3
  • 2
5 Comments
 
LVL 40

Accepted Solution

by:
Gurvinder Pal Singh earned 2000 total points
ID: 37804748
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
 

Author Comment

by:daydreamer6565
ID: 37805395
Now the error is gone..bt the values are not displayed on the table..what cud be the issue..
0
 
LVL 40

Expert Comment

by:Gurvinder Pal Singh
ID: 37805476
Please put the print statements to check if the data is correctly retrieved from database
0
 

Author Comment

by:daydreamer6565
ID: 37809521
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
 

Author Comment

by:daydreamer6565
ID: 37810154
I got the values inside my table ..
now the issue is regarding Date only how to get the correct format?
pls help
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question