Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert string into java.sql.Date

807569Aug 3 2006 — edited Aug 3 2006
Hi,

I want to convert a date in string form into java.sql.Date to persist into the database column with Date as its datatype in Oracle. I'm trying as follows:

import java.sql.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;

public class DateTest
{
public static void main(String[] args)
{
String strDate = "2002-07-16 14:45:01";
System.out.println("strDate = "+strDate);
Date aDate = null;
try
{
if(strDate != null && !strDate.trim().equals(""))
{
SimpleDateFormat aSDF = new SimpleDateFormat();
aSDF.applyPattern("yyyy-MM-dd hh:mm:ss");

java.util.Date utilDate = aSDF.parse(strDate);
System.out.println("utildate = "+utilDate);

aDate = new Date(utilDate.getTime());
aDate.setTime(utilDate.getTime());
System.out.println("aDate = "+aDate);
}
}
catch (ParseException e)
{
System.out.println("Unable to parse the date - "+strDate);
}
catch (Exception ex)
{
ex.printStackTrace();
System.out.println("Caught Exception :"+ex.getMessage());
}
}
}

It gives the output as :

strDate = 2002-07-16 14:45:01
utildate = Tue Jul 16 14:45:01 IST 2002
aDate = 2002-07-16

If I put this value into the database table, I can see only the date. Time part is missing. Is this the problem with java.sql.Date or Oracle datatype Date? Please help me asap.

Thanks in advance.

Regards,
Rajapriya.R.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2006
Added on Aug 3 2006
4 comments
385 views