What is the COBOL picture clause of the following DB2 data
types: DATE, TIME, TIMESTAMP?
Answers were Sorted based on User's Feedback
Answer / islam
date pic x(10)
time pic x(08)
timestamp pic x(26)
Is This Answer Correct ? | 40 Yes | 3 No |
Answer / kalyani
DATE PIC X(10)
TIME PIC X(8)
TIMESTAMP PIC X(26)
Is This Answer Correct ? | 23 Yes | 2 No |
Answer / 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 |
Is db2 relational database?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
what is the difference between declaring the cursor in WS section and Procedure division?
Explain what are the various isolation levels possible?
Which component is responsible for db2 startup and shutdown?
What are the contents of dclgen?
What are the advantages of using a PACKAGE?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is bind plan?
How to see the structure of db2 table??
How to find the maximum value in a column in the db2 database?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?