Change Data Type Example

Now we want to change the data type of the column named "DateOfBirth" in the "Persons" table.

We use the following SQL statement:
 

Notice that the "DateOfBirth" column is now of type year and is going to hold a year in a two- or four-digit format.

Practice Excercise Practice now