Solved

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

Posted on 2012-04-03
5
778 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:
gurvinder372 earned 500 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:gurvinder372
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
noX challenge 17 77
endX challenge 2 50
Exception after setting jdbc session management 2 38
Requested array size exceeds VM limit 3 51
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now