convert varchar -> datetime with <nulls> and dd/mm/yyyy 00:00:00 in field [out-of-range error]
Posted on 2004-10-01
I have 40,000 records which I want to to convert the date of birth field.
the field has about 50% of <NULL> and the rest have dates.
The dates are in the format for example 04/05/1977 0:00:00
I can remove the 0:00:00 because it is not relevant. (Is there an SQL command I can use to remove all of these?)
Is the NULL or the time causing the out-of-range error and is there any way around this?
I need to convert it to add more date records and dates not varchars in the future.