date problem

[syidah mk]

hi.. i need help in converting string to date.. i just need someone to check whether my code is correct or not..

here are my codes:


Date today = new Date();
DateFormat formatLong= DateFormat.getDateInstance(DateFormat.SHORT);
java.sql.Date curDate = java.sql.Date.valueOf(formatLong.format(today));

//and below is the storing part..

String query1 = null;
query1 = "Insert into ITS.dbo.orderDetails values(?)";

PreparedStatement stmnt = conn.prepareStatement(query1);


stmnt.setDate(1, curDate);

stmnt.executeUpdate();





anyone ..pls reply .. i need it urgently...
[ March 11, 2005: Message edited by: Bear Bibeault ]

[Daniel Rhoades]

Have a look at the SimpleDateFormat class:

http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

You can then format the date string much easier

[Bear Bibeault]

Moved to Java in General (intermediate)

[Yevgeniy Treyvus]

Have a look at this snippet...

public static void main(String args[]) {
DateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");
try {
//get date from string
Date date = dateFormat.parse("09/22/2002 13:45:59");
System.out.println(date);
} catch (ParseException e) {
throw new RuntimeException(e);
}

//get string from date
System.out.println(dateFormat.format(new Date()));
}

[Layne Lund]

I think your code looks fine. The main difference between using DateFormat.getInstance() and creating your own SimpleDateFormat is that the former provides a default format based on your systems settings (usually called the "locale"). The later, on the other hand, allows you to create custom date formats as illustrated.

Layne

[syidah mk]

Originally posted by Yevgeniy Treyvus:
Have a look at this snippet...

public static void main(String args[]) {
DateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");
try {
//get date from string
Date date = dateFormat.parse("09/22/2002 13:45:59");
System.out.println(date);
} catch (ParseException e) {
throw new RuntimeException(e);
}

//get string from date
System.out.println(dateFormat.format(new Date()));
}

i'm sorry guys.. i'm a slow learner but keen to know abt this.. i don't understand wat this means.. i'm using JSP.. so where do i put this codes??

i have this solution:
java.util.Date today = new java.util.Date();//creating date
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");//format definition
java.sql.Date curDate = java.sql.Date.valueOf(sdf.format(today));//creating SQL Date.

tried this solution but still get an error...
Syntax error converting datetime from character string.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

pls help ..

[syidah mk]

anybody there pls help .. need this to solve it by this week..

[syidah mk]

anybody there pls help .. need this to solve it by this week..

[Yevgeniy Treyvus]

I am not quiet sure on what you're trying to do....Are you trying to get a java.sql.Date from a String, or are you trying to get a java.sql.Date from java.util.Date?? The following snippet should answer both of those questions.

DateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");
try {
//get date from string
Date date = dateFormat.parse("09/22/2002 13:45:59");
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
System.out.println(sqlDate);
} catch (ParseException e) {
throw new RuntimeException(e);
}