Extracting a year and month data into a different column
I am trying to add a new colum into my table with the year and month data only from an existing date field. Who can assist me here kindly
1 answers ( 0 marked as helpful)
Hi Cosmas!
Thanks for reaching out.
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
The syntax is the following:
ALTER TABLE table_name
ADD column_name datatype;
Hope this helps.
Best,
Tsvetelin
