What is the physical storage length of the data types date, time, and timestamp?
- 1 Answers
- 1171 Views
- I also Faced
- E-Mail Answers
Answer Posted / Saurabh Yadav
The physical storage lengths for DATE, TIME, and TIMESTAMP data types in DB2 are as follows:nn- DATE: 7 bytes (YYMMDD)n- TIME: 5 bytes (HHMMSS.FF)n- TIMESTAMP: 9 bytes (YYMMDD HH:MI:SS.FF)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the latest version of ibm db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
