Interested to Buy Any Domain ? << Click Here >> for more details...
What is the COBOL picture clause of the following DB2 data
types: DATE, TIME, TIMESTAMP?
- 3 Answers
- 20355 Views
- I also Faced
- E-Mail Answers
Answer Posted / kkings
DATE • Represented as a sequence of eight unsigned
packed decimal digits (yyyymmdd), occupying four bytes.
• Range 00010101 to 99991231 A.D.
TIME • Represented as a sequence of six unsigned
packed decimal digits (hhmmss), occupying three bytes.
• Range 000000 to 240000.
TIME STAMP • Is a combination of date and time,
accurate to the nearest microsecond.
• Represented as a sequence of 20 unsigned packed
decimal digits (yyyymmddhhmmssnnnnnn), occupying ten bytes.
• Range 00010101000000000000 to 99991231240000000000.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is db2 free?
can we view the access paths created by dbrm ? how ? thx
Explain package in db2 and its advantages?
Give a brief description of db2 isolation levels?
How many databases can be created inside an instance in db2 ?
How do I change the column size in db2?
When do you specify the isolation level?
What is dbrm? What it contains?
What is ibm db2 connect?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Name the various locking levels available?
What is cursor in dbms?
What do you mean by rollback?
What is the meaning concurrency in the db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
