Convert String to Timestamp Java

Question

So I am having this issue that I can't wrap my head around. I've read similar questions posed but very case I've found there is an issue with the format, and my format is correct.

Basically I am trying to convert a String into a Timestamp, and I get the unparseable date error.

import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
public class Hello {

public static Timestamp convertStringToTimestamp(String str_date) {
    try {

        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss,SSS");
        Date date = formatter.parse(str_date);
        java.sql.Timestamp timeStampDate = new Timestamp(date.getTime());
        return timeStampDate;

    } catch (ParseException e) {
        System.out.println("Exception :" + e);
        return null;
    }
}

public static void main(String[] args) {
    Timestamp ts = convertStringToTimestamp("2015-06-09 11:51:12,708");
    Timestamp ts2 = convertStringToTimestamp("2015-04-17 11:29:49.564");
    System.out.println(ts +" | "+ts2);


}

}

Output:

Exception :java.text.ParseException: Unparseable date: "2015-06-09 11:51:12,708"
Exception :java.text.ParseException: Unparseable date: "2015-04-17 11:29:49.564"
null | null

Any ideas?

yes, you have `,` in your date format, and in your date string you have `.` try change this, and it should work — user902383, Jun 23 '15 at 14:54
Your code works perfectly fine for the first date in my machine... Are you using a custom JRE or something??? — Codebender, Jun 23 '15 at 15:04
are you sure it is right code? try to rebuild it and run again, it looks like you are running old code — user902383, Jun 23 '15 at 16:21

score 0 · Answer 1 · answered Jun 23 '15 at 14:57

This works perfectly to me.

I just passed the right pattern as an input as well.

public static Timestamp convertStringToTimestamp(String str_date, String pattern) {
        try {

            SimpleDateFormat formatter = new SimpleDateFormat(pattern);
            Date date = formatter.parse(str_date);
            java.sql.Timestamp timeStampDate = new Timestamp(date.getTime());
            return timeStampDate;

        } catch (ParseException e) {
            System.out.println("Exception :" + e);
            return null;
        }
    }

    public static void main(String[] args) {
        Timestamp ts = convertStringToTimestamp("2015-06-09 11:51:12,708", "yyyy-MM-dd HH:mm:ss,SSS");
        Timestamp ts2 = convertStringToTimestamp("2015-04-17 11:29:49.564", "yyyy-MM-dd HH:mm:ss.SSS");
        System.out.println(ts +" | "+ts2);


    }

The output is:

2015-06-09 11:51:12.708 | 2015-04-17 11:29:49.564

Yes this works, however it is troublesome to pass the formatter as argument, but I understand why you did it due to my comma/dot implementation. Thanks! — jensd, Jun 23 '15 at 15:17
Since there's 2 kinds of patterns I follow this approach. Hope that helps. :-) — Eduardo Briguenti Vieira, Jun 23 '15 at 17:31

score 0 · Answer 2 · answered Jun 23 '15 at 14:57

0

"2015-06-09 11:51:12,708" is working for me but "2015-04-17 11:29:49.564" won't. You specified the regex for "," so "." would not. It is perfectly normal.

answered Jun 23 '15 at 14:57

Sezin Karli

2,517
19
24

score 0 · Answer 3 · answered Jun 23 '15 at 14:59

0

you need to fix the comma

Timestamp ts2 = convertStringToTimestamp("2015-04-17 11:29:49.564");

answered Jun 23 '15 at 14:59

Mudassar

3,135
17
22

ASP · Accepted Answer · 2015-06-23T15:16:39.447

-2

**Update**
import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;


public class SomeClass {

    public static void main(String[] args) {


         System.out.println(convertStringToTimestamp("2015-06-09 11:51:12,708"));
         //be consistent here with , and .
         System.out.println(convertStringToTimestamp("2015-04-17 11:29:49.564"));
         System.out.println();


    }

    private static Timestamp  convertStringToTimestamp(String something) {


SimpleDateFormat dateFormat = null;
        if(something.contains(".")) {
            dateFormat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.SSS");
        } 
        if(something.contains(",")) {
            dateFormat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss,SSS");
        }
        Timestamp timestamp = null;
            Date parsedDate;
            try {
                parsedDate = dateFormat.parse(something);
                 timestamp = new java.sql.Timestamp(parsedDate.getTime());

            } catch (ParseException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            return timestamp;
    }



}

edited Jun 23 '15 at 15:16

answered Jun 23 '15 at 14:53

ASP

437
4
11

@Jesper it solves the problem with this "Timestamp timestamp = new java.sql.Timestamp(parsedDate.getTime());" is it so difficult to understand ? – ASP Jun 23 '15 at 14:57
But this is not different from what the OP already posted. (Carefully look at the code in the question). – Jesper Jun 23 '15 at 14:58
So this works if you input the pattern directly into the dateFormat.parse() However, with your solution, and trying to fit the inputted string still returns the parseException, disregarding of ',' or '.' (comma dot) – jensd Jun 23 '15 at 15:00
@jensd I have updated the code ... this code should work you have to be more consistent with ',' and '.' because at format we are specifying ',' – ASP Jun 23 '15 at 15:07
Yes this works, also some other submitted examples works as well. Thank you. – jensd Jun 23 '15 at 15:16
Awesome mate ... made last edits if you still want to use ',' and '.' ;) – ASP Jun 23 '15 at 15:17

Convert String to Timestamp Java

4 Answers4