Date or Timestamp?
posted 8 years ago
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
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
posted 8 years ago
Davie,
You are correct. Timestamp stores both date and time in a database. Date stores just date.
You are correct. Timestamp stores both date and time in a database. Date stores just date.
[OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
| With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |