Add a Date column
I want to add a column to the end of a existing Table that has data in it. I need the column to contain DATE information and then after inserting the column I need to make all the rows values for that new added column to be in this format:
Month-Year there is no need for an exact Date format like: 01/01/2008 TIME, just MM/YYYY
I think this has worked for me in the past, but I am not sure about the DATE parts that I want and I am not sure how to insert say MARCH/2009 into all the rows, help would be appreciated, thanks!
alter Table Y775.TABLE
add
SPEND_GROUP DATE;
COMMIT;