-2

How convert this string to dateTime?

2016-01-09 21:04:56.0

I tried

private Date getDate(CallDetail callDetail) {
        Date date = null;
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");
        try {
            date = simpleDateFormat.parse(callDetail.getStarttime());
        } catch (ParseException e) {
            e.printStackTrace();
        }
        return date;
    }

But I have error:

Unparseable date: "2016-01-09 21:04:56.0"

I do not know how trim .0

RockAndRoll
  • 2,247
  • 2
  • 16
  • 35
user5620472
  • 2,722
  • 8
  • 44
  • 97

3 Answers3

2

Your format string has to represent the string you want to parse.

E.g. if you want to parse 25.12.2015 your format string has to be "dd.MM.yyyy".

With that being said, your format string to parse the given date should be "yyyy-MM-dd HH:mm:ss:S"


If you just want to get rid of the milliseconds you could either parse the date and format it it afterwards:

String toParse = "2016-01-09 21:04:56.0";
SimpleDateFormat sdfIn = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
Date newDate = sdfIn.parse(toParse);
SimpleDateFormat sdfOut = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
toParse = sdfOut.format(newDate);

or just cut off the milliseconds with substring():

String toParse = "2016-01-09 21:04:56.0";
toParse = toParse = toParse.substring(0, toParse.lastIndexOf("."));
ParkerHalo
  • 4,341
  • 9
  • 29
  • 51
0

Try using below format "yyyy-MM-dd hh:mm:ss.S"

public static void main(String[] args) throws ParseException {
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat(
                "yyyy-MM-dd hh:mm:ss.S");
        Date date = simpleDateFormat.parse("2016-01-09 21:04:56.0");
        System.out.println(date);
    }

output

Sat Jan 09 21:04:56 IST 2016
Ankur Singhal
  • 26,012
  • 16
  • 82
  • 116
0

The modern way is with the java.time classes and standard ISO 8601 formats.

ISO 8601

The ISO 8601 standard defines many formats for representing date-time values as text. For a date with time-of-day, the format is YYYY-MM-DDTHH:MM:SS.s.

The java.time classes use these standard formats by default when parsing and generating strings.

Your input string can be made to comply easily. Replace the SPACE in the middle with a T.

String input = "2016-01-09 21:04:56.0".replace( " " , "T" );

LocalDateTime

Your input string lacks any indication of time zone or offset-from-UTC. So we parse as a LocalDateTime object.

LocalDateTime ldt = LocalDateTime.parse( input );

Your goal seems to be generating a string of this date-time value without the fractional second if zero. The LocalDateTime class does this by default, printing zero, three, six, or nine digits of fractional second, the least needed.

String output = ldt.toString();

2016-01-09T21:04:56

For your desired format, replace the T with a SPACE.

String output2 = output.replace( "T" , " " );

A LocalDateTime intentionally lacks any time zone. As such, it does not represent a moment on the timeline. That requires the context of a time zone.

Truncation

If you want to get rid of the fractional second, truncate.

LocalDateTime ldtTruncated = ldt.truncatedTo( ChronoUnit.SECONDS );

About java.time

The java.time framework is built into Java 8 and later. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat.

The Joda-Time project, now in maintenance mode, advises migration to the java.time classes.

To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310.

Where to obtain the java.time classes?

  • Java SE 8 and SE 9 and later
    • Built-in.
    • Part of the standard Java API with a bundled implementation.
    • Java 9 adds some minor features and fixes.
  • Java SE 6 and SE 7
    • Much of the java.time functionality is back-ported to Java 6 & 7 in ThreeTen-Backport.
  • Android

The ThreeTen-Extra project extends java.time with additional classes. This project is a proving ground for possible future additions to java.time. You may find some useful classes here such as Interval, YearWeek, YearQuarter, and more.

Community
  • 1
  • 1
Basil Bourque
  • 303,325
  • 100
  • 852
  • 1,154