yyyy mm dd hh mm ss nnnnnn 2 + 1 + 1 +1+ 1+ 1+ 3 = 10 Internal represent

What is the format (internal layout) of ?TIMESTAMP??

Question Posted / s

1 Answers
5821 Views
I also Faced
E-Mail Answers

Answer Posted / s

yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dbrm?

1180

What types of tables are there in the db2 database?

1101

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2118

What do you mean by rollback?

1031

How does cobol compile db2 program?

1130

What is syscat in db2?

1072

What is a cursor in programming?

1113

How does a cursor work?

1042

What is the result of open cursor statement?

1128

Explain package in db2 and its advantages?

1273

What is the use of dclgen in db2?

1135

What is an instance database?

1098

What is the physical storage length of time data type?

1178

What are union and union all?

1039

What is the maximum size of a char data type in db2?

1053