A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
EJB 3 in Action
this week in the
EJB and other Java EE Technologies
inserting a string containing date into oracle table which has the date type field
Joined: Dec 05, 2004
Dec 05, 2004 08:49:00
i have a html page which accepts the date from text box in dd/mm/yyyy format.
is stored in string variable in next jsp page.
now how can i store this string variable into oracle table which has coloumn with date data type.
Joined: May 26, 2003
Dec 05, 2004 17:43:00
Welcome to JavaRanch!
Take a look at the
class. This converts your String into a Date. Then you can use stmt.setDate() and let Oracle worry about the database format.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Joined: Aug 13, 2004
Dec 06, 2004 00:41:00
You can do it in either way either convery string into Date typoe in Java Code or Do it in Oracle.
To do same in oracle,simply you can use to_date function of oracle to covert your string into date type
Syntax is to_date(String,Format)
if you want to insert a date ie 06/12/2004 in dd/mm/yyyy format,
You can do same like this
insert into table_name(Date_column) values(to_date('06/12/2004','dd/mm/yyyy'))
[ December 06, 2004: Message edited by: Shailesh Chandra ]
Gravitation cannot be held responsible for people falling in love ~
I agree. Here's the link:
subject: inserting a string containing date into oracle table which has the date type field
Date Conversion in SQL
SQL to retrieve date vals from ORA-DB
parsing in servlet
Passing date and time using Timestamp.
java.sql.Timestamp to Oracle date
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014