first enter current date or anyother date in this field as you want than alter the column. then it will work. because in your field there is null value stored so it is giving error.
update tbl_user_login set created_date=@Date where created_date is null
alter table tbl_user_login alter column created_date datetime not null