Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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
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: 60782
    
  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: 18541
    
    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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Conversion
 
Similar Threads
Mapping Oracle DATE to java.sql.Date ?
Access Autonumber
Objects and Constructs.
What replaces deprecated getDate() ???
Representing MilliSeconds in JDBC using Oracle