I am new to Teradata. Now one of my work involves pulling data from Teradata and populat into Oracle tables. I have to pull data that falls between a particular date range.I have a table, where date is stored as YYYYMM Integer format ( ex 200607). How can I convert this into a date field like, say 01/07/2006 ?. I tried Date Format, cast functions, but nothing works.