Java Database Connectivity (JDBC)

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!

converting a Java Date string into SQL Server datetime

843859Feb 6 2007 — edited Feb 7 2007

Hi,

I have this problem. I need to be able to convert a java Date string into a SQL Server datetime value.

In other words, I have the following string in my database:
Mon Mar 06 14:33:57 EST 2006

and now this varchar(50) field in my table needs to be converted to the datetime field, which should convert this string to:
2006-03-06 14:33:57

Thanks a lot!
VG

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2007

Added on Feb 6 2007

#java-database-connectivity-jdbc

4 comments

482 views