How do I convert a Joda Time DateTime object into a String in SQL Server format?

sanity_16050 0
Viewed 44333

I am using the Joda-Time library in Java, and have a date and time stored as an org.joda.time.DateTime object.

How can I reliably convert this DateTime object into a String that will be parsed correctly by SQL server (including timezone), such that I can use it in an INSERT SQL statement?

jdbc jodatime sql-server java
4 Answers

you can try this simple code : 

DateTime dt = new DateTime();
DateTimeFormatter fmt = DateTimeFormat.forPattern("yyyy-MM-dd HH:mm:ss");
String dtStr = fmt.print(dt);
user_13057640
Related