Java SimpleDateFormat cut trailing 0-digits of SSS

Question

hi i have an simple date format

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");

It formats the date like this

2014-04-23 13:15:59.390

is it possible to remove the trailing 0, except when the digit it it is not 0?

2014-04-23 13:15:59.39

ok i've found my problem

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");

gives me what i want, the problem is that i'm comparing it with a date-string which comes from a database.

The database reads it from a timesamp column, which contains the correct value, but i'm reading it with a

resultSet.getString(i)

and for some reason it cutts the last digit... So my question should be, why does resultSet.getString cut the last character when reading a date field?

what if it ends in `00` - how many zeroes should be trimmed? What about `000`? — Bohemian, Apr 23 '14 at 13:32
As per the java reference "Fractional seconds are handled specially: they're zero-padded on the right.", you'll have to probably convert to string and remove it manually. — Matt K, Apr 23 '14 at 13:32
sorry i think now my question is pointless... i first need to get sure what i really want ^^ i'll close it — wutzebaer, Apr 23 '14 at 13:34
@wutzebaer Do not close your question, it can be useful to other people. — Matt K, Apr 23 '14 at 13:36
ok if you still like my question: i've continued my story =) — wutzebaer, Apr 23 '14 at 13:43
@wutzebaer Do not alter the essence of your Question. When you discover a new question, make a new Question posting to StackOverflow. — Basil Bourque, Apr 23 '14 at 13:55

score 2 · Accepted Answer · answered Apr 23 '14 at 13:32

2

Use String methods to trim a trailing zero:

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format(date).replaceAll("0$", "");

To trim up to 2 trailing zeroes:

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format(date).replaceAll("0?0$", "");

answered Apr 23 '14 at 13:32

Bohemian

412,405
93
575
722

Does he want to trim or to preserve them? – chris polzer Apr 23 '14 at 13:34
Wouldn't that trim the zeros in the date as well? – Matt K Apr 23 '14 at 13:35
@Bohemain i think you should know replaceAll method in which class exist – Asif Bhutto Apr 23 '14 at 13:36
1

@MattK No. The `$` anchor is "end of input" - it will only match at the end – Bohemian Apr 23 '14 at 13:36

score 2 · Answer 2 · answered Apr 23 '14 at 13:37

2

On the resulting string, do a replaceFirst("[0]*$", "")

For example:

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format(new Date()).replaceFirst("[0]*$", "")

answered Apr 23 '14 at 13:37

Dhrubajyoti Gogoi

1,265
10
18

score 0 · Answer 3 · answered Apr 23 '14 at 13:30

0

It could be a locale-specific issue you are getting. Try this:

new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS", Locale.ENGLISH);

answered Apr 23 '14 at 13:30

Denis Kulagin

8,472
17
60
129

Java SimpleDateFormat cut trailing 0-digits of SSS

3 Answers3