Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with Date conversion from PostgreSQL database

 
zsa tan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good morning!

I have a question regarding date conversion from Postgresql DB.
You see I am querying a date from the DB

when I view the values they are in this sample format
"1982-01-14 12:34:56.000000 +08:00:00"

I would retrieve the date column
rs.getDate(note this is in date type)
I would store them in an object with the birthday attribute (which is a Date type)

my question is how can i convert tahat into Jan, 01. 1982?

 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would store them in an object with the birthday attribute (which is a Date type)

A Date does not hold any format. You don't need to do anything.

my question is how can i convert tahat into Jan, 01. 1982?

Why ? You want to hold it as a String ? If yes, you can do it using SimpleDateFormat. Can you find out which format to use ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic