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 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Similar Threads
JDBC SQL server date format problem
SQL server date format
Formatting Date Object
Reading date from Excel Spreadsheet
Converting String to Date Object(mm/dd/yy) format