I want to enter date in format mm-dd-yyyy hh:mm:

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

(Continued from previous question...)

I want to enter date in format mm-dd-yyyy hh:mm:Ss in DB2. How can I do that?

A: Well, first of all, in DB2 the combination of date and time is known as a TIMESTAMP data type, so you will need to use TIMESTAMP as the data type instead of DATE (which is just the date with no time component). Other DBMSs use the DATE data type to store both date and time data, but not DB2.

     YYYY is year
     MM is month
     DD is day
     HH is hour
     MM is minutes
     SS is seconds and
     mmmmmm is microseconds

That is the only acceptable format of DB2 timestamp data.

(Continued on next question...)

Other Job Interview Questions

• My format does not fit into any of these listed in question 1. What if I have a DATE stored like YYYYMMDD (with no dashes or slashes) and I want to compare it to a DB2 date?
• Is there a way in DB2 date arithmetic to express the duration resulting from date subtraction, as a total-number-of-days (exact total, and not an approximate total)?
• My format does not fit into any of these listed in question 1. What if I have a DATE stored like YYYYMMDD (with no dashes or slashes) and I want to compare it to a DB2 date?
• My format does not fit into any of these listed in question 1. What if I have a DATE stored like YYYYMMDD (with no dashes or slashes) and I want to compare it to a DB2 date?
• I want to fetch a date column with the 'DD-MMM-YYYY' format. Can I do it in a single query?
• I want to enter date in format mm-dd-yyyy hh:mm:Ss in DB2. How can I do that?
• Is there a way in DB2 date arithmetic to express the duration resulting from date subtraction, as a total-number-of-days (exact total, and not an approximate total)?
• Is there a way in DB2 date arithmetic to express the duration resulting from date subtraction, as a total-number-of-days (exact total, and not an approximate total)?
• I'm confused about how DB2 handles date arithmetic! It seems that I can subtract a date from a date, or a time from a time, but what will DB2 return as the result of such a calculation? Please help?
• My format does not fit into any of these listed in question 1. What if I have a DATE stored like YYYYMMDD (with no dashes or slashes) and I want to compare it to a DB2 date?
• More...