File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes JDBC SQL server date format problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC SQL server date format problem" Watch "JDBC SQL server date format problem" New topic
Author

JDBC SQL server date format problem

sanjay vishwas
Greenhorn

Joined: Nov 16, 2005
Posts: 2
in my application i am using JDBC ODBC bridge to connect to the SQL server database.its a JSP appication.
when i insert date to database it gets inserted in the format of mm/dd/yy but when i display it in the next page through resultset using getString method it displayes in the format of yy/mm/dd.
is there any method by which i can convert date in the format of mm/dd/yy.
Sri Ram
Ranch Hand

Joined: Oct 03, 2005
Posts: 118
Originally posted by sanjay vishwas:
in my application i am using JDBC ODBC bridge to connect to the SQL server database.its a JSP appication.
when i insert date to database it gets inserted in the format of mm/dd/yy but when i display it in the next page through resultset using getString method it displayes in the format of yy/mm/dd.
is there any method by which i can convert date in the format of mm/dd/yy.


Use DateFormat Class to change the format. Then display it in Screen.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC SQL server date format problem