Last answered:

27 May 2022

Posted on:

11 May 2022


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)
Posted on:

27 May 2022


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.

Submit an answer