Updating records in a table

Below query will update the birth date of the customer having id as 1.
Note that date must be in the yyyymmdd format or yyyy-mm-dd format.

UPDATE CUSTOMER SET BirthDate=’19860109′ WHERE CustomerId=1;

You may also like...