Convert Java String to sql.Timestamp

Question

Got a String coming in with this format: YYYY-MM-DD-HH.MM.SS.NNNNNN The Timestamp is coming from a DB2 database. I need to parse it into a java.sql.Timestamp and NOT lose any precison. So far I've been unable to find existing code to parse that far out to microseconds. SimpleDateFormat returns a Date and only parses to milliseconds. Looked at JodaTime briefly and didn't see that would work either.

Answer 1

Have you tried using Timestamp.valueOf(String)? It looks like it should do almost exactly what you want - you just need to change the separator between your date and time to a space, and the ones between hours and minutes, and minutes and hours, to colons:

import java.sql.*;  public class Test {     public static void main(String[] args) {         String text = "2011-10-02 18:48:05.123456";         Timestamp ts = Timestamp.valueOf(text);         System.out.println(ts.getNanos());     } } 

Assuming you've already validated the string length, this will convert to the right format:

static String convertSeparators(String input) {     char[] chars = input.toCharArray();     chars[10] = ' ';     chars[13] = ':';     chars[16] = ':';     return new String(chars); } 

Alternatively, parse down to milliseconds by taking a substring and using Joda Time or SimpleDateFormat (I vastly prefer Joda Time, but your mileage may vary). Then take the remainder of the string as another string and parse it with Integer.parseInt. You can then combine the values pretty easily:

Date date = parseDateFromFirstPart(); int micros = parseJustLastThreeDigits();  Timestamp ts = new Timestamp(date.getTime()); ts.setNanos(ts.getNanos() + micros * 1000);