What is the COBOL picture clause of the following DB2 data
types: DATE, TIME, TIMESTAMP?
- 3 Answers
- 19021 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
How to resolve deadlock issue
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the prerogatives?
What is database reorganization?
What is meant by union and union all?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How do I add a column in db2?
What is syscat in db2?
How and when does the db2 enforces the unique key?
Is db2 a mainframe database?
What is runstats db2?
What is a db2 cursor?
How to find schema of a table in db2?
What's The Percentage Free Space ?
Explain the contention situations caused by locks?
