Converting java sql timestamp to String

Question

Im having a little trouble converting a sql timestamp to string, their outputs are different.

@Temporal(javax.persistence.TemporalType.TIMESTAMP)
private Date auctionStart;

public void setTime(){
    SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
    String aucStartString = f.format(auctionStart);


}

My auctionStart date prints: 04-Apr-2017 17:14:10 When i convert it to string it prints: 2017-04-04 05:14:10

It looks like the hours are converting to 12 hour format, any ideas how to correct it?

Possible duplicate of 24 hour in SimpleDateFormat() and milliseconds in java — Daniel Bickler
– Daniel Bickler, Commented Apr 5, 2017 at 0:03

freedev · Accepted Answer · 2017-04-05 00:12:57Z

2

Try using H instead of h for the hours as from Class SimpleDateFormat javadoc.

H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12

SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

UPDATE

Date auctionStart = new Date(2017-1900,4,4,17,14,10);

    SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    String aucStartString = f.format(auctionStart);
    System.out.println(aucStartString);

Prints

2017-05-04 17:14:10

edited Apr 5, 2017 at 0:12

answered Apr 5, 2017 at 0:02

freedev

30.9k12 gold badges129 silver badges141 bronze badges

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

3 Comments

HazardAGuess Over a year ago

thanks for your help but it is still printing as 2017-04-04 05:14:10 with adding HH

freedev Over a year ago

impossible. double check my answer please

HazardAGuess Over a year ago

Yes, apologies must not have compiled first try, Thanks for the help.

Daniel Bickler · Accepted Answer · 2017-04-04 23:59:41Z

0

Per the SimpleDateFormat javadoc, you want

SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

Edited because I originally put 'kk' instead of 'HH' which is most likely not what you want. 'kk' shows hour as 1-24 while 'HH' shows hour as the more common 0-23.

answered Apr 4, 2017 at 23:59

Daniel Bickler

1,15014 silver badges29 bronze badges

Collectives™ on Stack Overflow

Converting java sql timestamp to String

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related