DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What are the three DB2 date and time data types

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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).

(Continued on next question...)

Other Job Interview Questions