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
- 20517 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
What is host variable?
How to test SQL -911 error while developing COB-DB2 program
What is the clustering index in the db2 database?
How do you find the maximum value in a column in db2?
How can you classify the locks in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is the use of dclgen in db2?
What is the advantage in De-normalizing tables in DB2?
What types of tables are there in the db2 database?
What is host variable in db2 cobol?
Explain various types of locks in db2?
What is buffer pool and list some of them?
Highlight all the advantages that are attached to a package.
What is the difference between nvl and coalesce?
How do I change the column size in db2?
