What are the three DB2 date and time data types and their associated functions?

The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It's Y2K compliant).
  • Interview Candidate
  • 3
  • 2161

Showing Answers 1 - 3 of 3 Answers

burelamanohar

  • Feb 6th, 2007
 

DATE PIC X(10)
TIME PIC X(8)
TIMESTAMP PIC X(26)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions