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 Conversion 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 "Conversion" Watch "Conversion" New topic
Author

Conversion

Ramesh Pappala
Ranch Hand

Joined: Sep 14, 2005
Posts: 50
I got the date value from the html file to my servlet by using the below code,

hiredate=req.getParameter("hiredate");

how to convert this hiredate into "SQL DATE" type. (ORACLE)

Please give an example code.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60050
    
  65

SQL date conversion isn't a servlets-specific topic, so I'm moving this off to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18121
    
    8

I will let you check the API documentation pages to find out what "something" should be for whatever date format you expect to be receiving.
Ramesh Pappala
Ranch Hand

Joined: Sep 14, 2005
Posts: 50
Thank You Paul Clapham, for giving reply to my question. And the answer you have given is working.
Once again thanks for giving reply.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Conversion
 
Similar Threads
Representing MilliSeconds in JDBC using Oracle
Access Autonumber
What replaces deprecated getDate() ???
Mapping Oracle DATE to java.sql.Date ?
Objects and Constructs.