| Author |
Date or Timestamp?
|
Davie Lin
Ranch Hand
Joined: Aug 05, 2007
Posts: 294
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26173
|
|
Davie,
You are correct. Timestamp stores both date and time in a database. Date stores just date.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Date or Timestamp?
|
|
|
0
