Date or Timestamp?

[Davie Lin]

I have a table column that stores Date in default format 'dd-MON-yy'
I use JDBC to retrieve this column but I need it to display hour and minute and am/pm for my struts 2 app.

I am wondering if I should change the column to Timestamp instead of Date, does Timestamp record more info down to hour and minute compare to Date type?

Thanks in advance

[Jeanne Boyarsky]

Davie,
You are correct. Timestamp stores both date and time in a database. Date stores just date.