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
- 20422 Views
- I also Faced
- E-Mail Answers
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 it possible using max on a char column?
Describe major components of db2?
How to get the ddl of a table in db2?
What is the difference between drop table and delete table?
What does a deadlock mean in DB2?
How to restart a DB2 program?
How to execute stored procedures?
What is multi row fetch in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is auditing?
What is package in db2 mainframe?
COBOL 
