How to convert string date to Timestamp in java?

Question

I want to convert string Date into Timestamp in java. The following coding i have written.I have declare the date for date1 is: 7-11-11 12:13:14.

SimpleDateFormat datetimeFormatter1 = new SimpleDateFormat(
                "yyyy-MM-dd hh:mm:ss");
Date lFromDate1 = datetimeFormatter1.parse(date1);
System.out.println("gpsdate :" + lFromDate1);
Timestamp fromTS1 = new Timestamp(lFromDate1.getTime());

I want to convert 7-11-11 12:13:14 this string date into timestamp. Now i got the output is 0007-11-11 00:13:14.000000 +05:30:00 but i want ( 7-11-11 12:13:14) this format Timestamp date. Can anyone please help me. Thank you.

possible duplicate of Java Timestamp - How can I create a Timestamp with the date 23/09/2007? — Basil Bourque
– Basil Bourque, Commented Mar 28, 2014 at 16:55

Basil Bourque · Accepted Answer · 2015-10-27 08:55:30Z

27

All you need to do is change the string within the java.text.SimpleDateFormat constructor to: "MM-dd-yyyy HH:mm:ss".

Just use the appropriate letters to build the above string to match your input date.

edited Oct 27, 2015 at 8:55

Basil Bourque

347k130 gold badges950 silver badges1.3k bronze badges

answered Apr 30, 2010 at 5:09

Glen Robertson

1,1778 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

lakshmi Over a year ago

I changed the SimpleDateFormat like "yyyy-MM-dd HH:mm:ss". Now i got a answer is 2007-11-11 12:13:14.000000 +05:30:00, the problem is i cant add this value into my database table. I want to display the date and time format is 2007-11-11 12:13:14. How to do this..?

Mark Ormesher Over a year ago

Digging up an old post, but the included link is dead. For any one seeing this in the future, here's a working version: docs.oracle.com/javase/7/docs/api/java/text/…

Basil Bourque Over a year ago

No quite right. The original Question's use of 7 as a value for a year is a serious problem.

Basil Bourque · Accepted Answer · 2019-05-01 02:13:59Z

tl;dr

java.sql.Timestamp                  
.valueOf(                           // Class-method parses SQL-style formatted date-time strings.
    "2007-11-11 12:13:14"
)                                   // Returns a `Timestamp` object.
.toInstant()                        // Converts from terrible legacy classes to modern *java.time* class.

`java.sql.Timestamp.valueOf` parses SQL format

If you can use the full four digits for the year, your input string of 2007-11-11 12:13:14 would be in standard SQL format assuming this value is meant to be in UTC time zone.

The java.sql.Timestamp class has a valueOf method to directly parse such strings.

String input = "2007-11-11 12:13:14" ;
java.sql.Timestamp ts = java.sql.Timestamp.valueOf( input ) ;

java.time

In Java 8 and later, the java.time framework makes it easier to verify the results. The j.s.Timestamp class has a nasty habit of implicitly applying your JVM’s current default timestamp when generating a string representation via its toString method. In contrast, the java.time classes by default use the standard ISO 8601 formats.

System.out.println( "Output: " + ts.toInstant().toString() );

Jenya Miachyn · Accepted Answer · 2017-10-06 16:14:32Z

7

You can convert String to Timestamp:

String inDate = "01-01-1990"
DateFormat df = new SimpleDateFormat("MM-dd-yyyy");
Timestamp ts = new Timestamp(((java.util.Date)df.parse(inDate)).getTime());

edited Oct 6, 2017 at 16:14

answered Oct 6, 2017 at 16:08

Jenya Miachyn

1141 silver badge5 bronze badges

Comments

oz123 · Accepted Answer · 2013-01-28 11:32:24Z

4

Use capital HH to get hour of day format, instead of am/pm hours

edited Jan 28, 2013 at 11:32

oz123

29.1k30 gold badges133 silver badges196 bronze badges

answered Apr 30, 2010 at 5:06

MeBigFatGuy

28.7k8 gold badges64 silver badges68 bronze badges

Comments

Sireesh Yarlagadda · Accepted Answer · 2014-03-28 14:56:47Z

4

You can even try this.

   String date="09/08/1980";    // take a string  date
    Timestamp ts=null;  //declare timestamp
    Date d=new Date(date); // Intialize date with the string date
    if(d!=null){  // simple null check
        ts=new java.sql.Timestamp(d.getTime()); // convert gettime from date and assign it to your timestamp.
    }

answered Mar 28, 2014 at 14:56

Sireesh Yarlagadda

13.9k3 gold badges78 silver badges77 bronze badges

1 Comment

Akabelle Over a year ago

constructing a Date with a String parameter is deprecated since Java 8

Omar Martinez · Accepted Answer · 2019-02-07 22:14:22Z

2

Use below code to convert String Date to Epoc Timestamp. Note : - Your input Date format should match with SimpleDateFormat.

String inputDateInString= "8/15/2017 12:00:00 AM";
SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyy hh:mm:ss");

Date parsedDate = dateFormat.parse("inputDateInString");

Timestamp timestamp = new java.sql.Timestamp(parsedDate.getTime());

System.out.println("Timestamp "+ timestamp.getTime());

edited Feb 7, 2019 at 22:14

Omar Martinez

4396 silver badges19 bronze badges

answered Feb 7, 2019 at 21:57

Navdeep Ghotra

2113 silver badges4 bronze badges

Collectives™ on Stack Overflow

How to convert string date to Timestamp in java?

6 Answers 6

3 Comments

tl;dr

`java.sql.Timestamp.valueOf` parses SQL format

java.time

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

tl;dr

java.sql.Timestamp.valueOf parses SQL format

java.time

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related

`java.sql.Timestamp.valueOf` parses SQL format