[SQL] problem with date

[Shalini shikha]

How can I insert/update a null value in a date field. If a try a sql
statement like the following:

update customer set birth_date = '' where cust_id like 'xyz', I get a
error message saying: Bad date representation.

Thanks in advance,
Shalini