Collision of Date format between java.sql and SQL Server

Hi,
I have a doubt about setting date format for database field when I use java.sql.Date format in my java applications.There is a collision between SQL Server's "month/day/year' format and java.sql.Date class' "year/month/day" format.If I tried to store "year/month/day" format in SQL Server table I got the error "Microsoft ODBC SQLException, Optional feature not implemented". How can I store that kind of date in SQL Server? Can I create american date format in java?How?

Yours faithfully,
Ramesh RK

This should not happen.

Can you please post your java code part, including insert/update statement, and the code where you set the date?

Regards, Jan

See the code accidentally created as a new post.

You are using
ps.setDate(5,dtF5);
which should be taking care of the date setting for you.

There isn't a different format for java.sql.Date in Java. It just represents a number of milliseconds. If you output the date value before setting it in the prepared statement, is it correct?

I see (in the code thread) that your table column is defined as DateTime.

Try using setTimestamp() to set the value for the field.

This solved this person's similar problem.

Regards, Jan