I am a little confused with the date format in DB2 and need clarification.
1) While checking for a particular date in the WHERE clause in which format should i represent it? For eg. i want to check if begin date is GE 23/02/2009 then how do i code?
BEG_DT >= '23/02/2009' ---> Is this form of checking correct?
2) What is the internal format in which a date is stored in DB2 table?
3) I have learnt that DB2 format date is dd/mm/yyyy but when it stores internally, it gets stored in ISO format which is YYYY-MM-DD. IS my understanding correct? What is the difference between DB2 format and ISO format of date when it comes to storing and retrieving from database? Which one do we use?