I have a table that contains a column of dates. I want to insert a new column into the table that will give me the month of the dates column.
I know my code to extract the month from the dates column is..
extract (month from dates_column) as month
My question is, how do I insert this into an existing table?